Date.StartOfQuarter

Syntax

Date.StartOfQuarter(dateTime as any) as any

About

Returns the start of the quarter that contains dateTime. dateTime must be a date, datetime, or datetimezone value.

Example 1

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

Usage

Date.StartOfQuarter(#datetime(2011, 10, 10, 8, 0, 0))

Output

#datetime(2011, 10, 1, 0, 0, 0)