Date.QuarterOfYear

Syntax

Date.QuarterOfYear(dateTime as any) as nullable number

About

Returns a number from 1 to 4 indicating which quarter of the year the date dateTime falls in. dateTime can be a date, datetime, or datetimezone value.

Example

Find which quarter of the year the date #date(2011, 12, 31) falls in.

Usage

Date.QuarterOfYear(#date(2011, 12, 31))

Output

4