Power Query
published
Search
⌃K

Date.Day

Date.Day

Returns the day component.
function (optional dateTime as nullable any) as nullable any

Description

Returns the day component of a date, datetime, or datetimezone value.

Category

Date

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.
Date.Day(#datetime(2011, 5, 14, 17, 0, 0))
14