Date.Day

Updated on

Date.Day is a function in the Power Query M language that returns the day component of a date, datetime, or datetimezone value.

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

Syntax

Date.Day( dateTime as any ) as nullable number

Description

Date.Day extracts the day component from a provided dateTime (date, datetime, or datetimezone).

Examples

Get the day component of a date, datetime, or datetimezone value representing the date and time of 5/14/2011 05:00:00 PM.

// Output: 14
Date.Day( #datetime( 2011, 5, 14, 17, 0, 0 ) )

Learn more about Date.Day in the following articles:

Other functions related to Date.Day are:

BI Gorilla Blog

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/date-day