DateTime.Date Function in Power Query

The DateTime.Date function in Power Query extracts the date portion from a datetime value, returning it as a date value (without the time component).

Syntax

DateTime.Date(dateTime as any) as nullable date

Example: Extract the date component.

Power Query M

let
    Source = DateTime.Date(#datetime(2025,4,24,5,25,50))
in
    Source

The output of the above code is 24-4-2025. In the code format it looks like #date(2025, 4, 24).

Previous Next