← Back to Date functions

Date.StartOfQuarter

This function retrieves the beginning of the quarter where the specified dateTime falls. The dateTime parameter can be a date, datetime, or datetimezone value.

Syntax

Date.StartOfQuarter(dateTime as any) as any

About

This function retrieves the beginning of the quarter where the specified dateTime falls. The dateTime parameter can be a date, datetime, or datetimezone value.

Explanation

Locate the beginning of the quarter for October 10th, 2011, 8:00AM using Power Query MDate.StartOfQuarter function. The output will be #datetime(2011, 10, 1, 0, 0, 0).