DateTime.Date

DateTime.Date is a Power Query M function that returns the date component of the given date, datetime, or datetimezone value.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365

Syntax

DateTime.Date( dateTime as any ) as nullable date

Description

Returns the date component of dateTime, the given date, datetime, or datetimezone value.

Examples

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

// Output: #date( 2010, 12, 31 )
DateTime.Date( #datetime( 2010, 12, 31, 11, 56, 02 ) )

Related functions

Other functions related to DateTime.Date are:

• DateTime.Time

Last update: August 25, 2023 | Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/datetime-date
© 2023 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.