← Back to Date functions

Date.StartOfDay

This function retrieves the beginning of the day associated with the dateTime input. The dateTime parameter should be a date, datetime, or datetimezone data type.

Syntax

Date.StartOfDay(dateTime as any) as any

About

This function retrieves the beginning of the day associated with the dateTime input. The dateTime parameter should be a date, datetime, or datetimezone data type.

Explanation

Locate the beginning of the day for October 10th, 2011 at 8:00 AM using Power Query function MDate.StartOfDay. The output will show the date and time as October 10th, 2011 at 00:00:00.