DateTime.Date

Syntax

DateTime.Date(dateTime as any) as nullable date 

About

Returns the date component of the dateTime parameter if the parameter is a date, datetime, or datetimezone value, or null if the parameter is null.

Example 1

Find date value of #datetime(2010, 12, 31, 11, 56, 02).

Usage

DateTime.Date(#datetime(2010, 12, 31, 11, 56, 02))

Output

#date(2010, 12, 31)