Search notes:

Power Query M formula language: Keywords #date, #datetime, #time and #datetimezone

#date(year as number, month as number, day as number) as date
#datetime(year as number, month as number, day as number, hour as number, minute as number, second as number) as any
#time(hour as number, minute as number, second as number) as time
#datetimezone(year as number, month as number, day as number, hour as number, minute as number, second as number, offsetHours as number, offsetMinutes as number) as any

See also

Using Table.TransformColumnTypes to render dates in a date-format in Excel.

Index