FIRSTOFQUARTER

Returns the first day of the specified quarter.

Reporting Area(s)

General

Required Parameters

1. Month number (i.e. 1, -1)

Optional Parameters

None

Example(s)

FIRSTOFQUARTER(-3) returns the first day of the last quarter

FIRSTOFQUARTER(0) returns the first day of the last month in the current quarter

FIRSTOFQUARTER(0)-1 returns the last day of the of the last month in the previous quarter