DateOnly

The DateOnly() function only returns the date part without the time part of a date.

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.

Syntax

DateOnly(datetime)

DateOnly('2016-05-02T05:37:44') =>Result: 5/2/2016

DateOnly(unknowndatetime) =>Result: unknowndatetime

Parameters

Name	Type	Required	Description
datetime	date time	☑️	a date