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 .
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
