Date.Day
The day of the month, 1 to 31, of a date, datetime or datetimezone.
Group: Dates and times. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
Date.Day(dateTime as any) as nullable number| Parameter | Type | Description |
|---|---|---|
dateTime | any | A date, datetime or datetimezone value; null gives null. |
Returns
nullable number. The day of the month.
Examples
The day of an order
Date.Day(#date(2024, 3, 15))15The time of day plays no part
Date.Day(#datetime(2024, 3, 31, 23, 59, 0))31