Skip to main content

Date.StartOfQuarter

Returns the start of the quarter.

Syntax

Date.StartOfQuarter(
dateTime as any
) as any

Remarks

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

Examples

Example #1

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

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

Result:

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

Category

Date