Updated on

Date.StartOfDay is a Power Query M function that returns the start of the day represented by dateTime. Your input must be a date, datetime, or datetimezone value.

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


Date.StartOfDay( dateTime as any ) as any


Date.StartOfDay identifies the start of the day for a given dateTime parameter (of type date, datetime, or datetimezone).


Find the start of the day for October 10th, 2011, 8:00AM.

// Output: #datetime( 2011, 10, 10, 0, 0, 0 )
Date.StartOfDay( #datetime( 2011, 10, 10, 8, 0, 0 ) )

Other functions related to Date.StartOfDay are:

BI Gorilla Youtube Channel

Contribute » | Contributors: Rick de Groot
Microsoft documentation: