← Back to Date functions

Date.Day

This function retrieves the day component from a given date, datetime, or datetimezone value. The parameter "dateTime" specifies the input date, datetime, or datetimezone value from which the day comp...

Syntax

Date.Day(dateTime as any) as nullable number

About

This function retrieves the day component from a given date, datetime, or datetimezone value. The parameter "dateTime" specifies the input date, datetime, or datetimezone value from which the day component will be extracted.

Explanation

Retrieve the day information from a date, datetime, or datetimezone value for the specific date and time of 5/14/2011 05:00:00 PM. The function in Power Query to achieve this is MDate.Day(#datetime(2011, 5, 14, 17, 0, 0)), which will return the output as 14.