DateTime.Time
The time of day of a datetime or datetimezone, without the date.
Group: Dates and times. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
DateTime.Time(dateTime as any) as nullable time| Parameter | Type | Description |
|---|---|---|
dateTime | any | A datetime or datetimezone value; null gives null. |
Returns
nullable time. The time of day.
Examples
When in the day an order came in
DateTime.Time(#datetime(2024, 3, 15, 14, 30, 0))#time(14, 30, 0)Orders after 18:00
DateTime.Time(#datetime(2024, 3, 15, 19, 10, 0)) >= #time(18, 0, 0)true