The Date() function accepts numeric values for each part of a date, optionally with time, and returns it as a datetime value.
This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.
Returns a Date Time value compiled from the separate input values for each part.
Returns Unknown if one of the parameter values is unknown or outside the common valid date boundaries.
year
numeric
the year unit
month
numeric
the month unit (1 - 12)
day
numeric
the day unit (1 - 31)
hour
numeric
the hour unit (0 - 23)
minute
numeric
the minute unit (0 - 59)
second
numeric
the second unit (0 - 59)