Last updated 2 years ago
Was this helpful?
The DateOnly() function only returns the date part without the time part of a date.
DateOnly()
This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.
Returns the date only.
Returns Unknown if one of the parameter values is unknown or outside the common valid date boundaries.
Unknown
DateOnly(
datetime
)
DateOnly('2016-05-02T05:37:44') =>Result: 5/2/2016
DateOnly('2016-05-02T05:37:44')
DateOnly(unknowndatetime) =>Result: unknowndatetime
DateOnly(unknowndatetime)
date time
a date