1 of 1

Date

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.

Date(year, month, day)

Date(2022, 2, 17)=>Result: February 17, 2022

Date(1999, 15, 88)=>Result: unknown

Date(year, month, day, hour, minute)

Date(2022, 2, 17, 11, 15)=>Result: February 17, 2022 11:15

Date(2022, 2, 17, 50, 50)=>Result: unknown

Date(year, month, day, hour, minute, second)

Date(2022, 2, 17, 11, 15, 22)=>Result: February 17, 2022 11:15:22

Date(2022, 2, 17, 15, 80, 80)=>Result: unknown