This function retrieves the date portion of a dateTime, date, datetime, or datetimezone value.
Syntax
DateTime.Date(dateTime as any) as nullable date
About
This function retrieves the date portion of a dateTime, date, datetime, or datetimezone value.
Explanation
Locate the date value of the specific datetime value provided (#datetime(2010, 12, 31, 11, 56, 02)) using Power Query function MDateTime.Date(). The output will be #date(2010, 12, 31).