DateTime.Date
The date part of a datetime or datetimezone, without the time of day.
Group: Dates and times. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
DateTime.Date(dateTime as any) as nullable date| Parameter | Type | Description |
|---|---|---|
dateTime | any | A date, datetime or datetimezone value; null gives null. |
Returns
nullable date. The date; a date given comes back as it is.
Remarks
- A datetimezone gives the date of its own clock.
Examples
The day an order was placed
DateTime.Date(#datetime(2024, 3, 15, 14, 30, 0))#date(2024, 3, 15)Orders by day
let
Orders = #table(type table [Order = text, Placed = datetime], {{"A-101", #datetime(2024, 3, 15, 9, 5, 0)}, {"A-102", #datetime(2024, 3, 15, 22, 40, 0)}})
in
Table.AddColumn(Orders, "Day", each DateTime.Date([Placed]), type date)| Order | Placed | Day |
|---|---|---|
| A-101 | 2024-03-15 09:05:00 | 2024-03-15 |
| A-102 | 2024-03-15 22:40:00 | 2024-03-15 |