User Tools

Site Tools


syntax:functions:makedate

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

ArgumentTypeDescription
yearNumberA number value representing the 4-digit year of the date.
monthNumberA number value representing the month (1 to 12) of the date).
dayNumberA 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