Date functions

MakeDate

View as Markdown

The MakeDate function evaluates specified values representing individual date (year, month, day) and time (hour, minute, second) components and returns a datetime value in ISO format.

Syntax

MakeDate(year, month, day, [hour], [minute], [second])

Function arguments:

year(required) An integer representing the year.
month(required) An integer representing the month.
day(required) An integer representing the day of the month.
hour(optional) An integer representing the hour (in the 24-hour format).
minute(optional) An integer representing the minutes.
second(optional) An integer representing the seconds.

Example

MakeDate(2019, 1, 31, 16, 30, 00)

Returns the datetime value 2019-01-31 16:30:00 (January 31, 2019 4:30 PM).