syntax:functions:makedate
Table of Contents
MakeDate(year, month, day)
Category: Date and Time function
Description
This function returns a date serial number based on the year, month and day numeric values.
Arguments
| Argument | Type | Description |
|---|---|---|
| year | Number | A number value representing the 4-digit year of the date. |
| month | Number | A number value representing the month (1 to 12) of the date). |
| day | Number | A number value representing the day-of-the-month number (1 to 31). |
Return value type: Date serial number
Examples
makedate(2014, 1, 1) //Returns 41640 (Equivalent to January 1st, 2014.)
makedate(2020, 2, 28) //Returns 43889 (Equivalent to February 28th, 2020.)
See also
syntax/functions/makedate.txt · Last modified: 2021/09/25 17:04 by craigt