FIRSTOFMONTH

Returns the first day of the specified month.

Reporting Area(s)

General

Required Parameters

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

Optional Parameters

None

Example(s)

FIRSTOFMONTH(1) returns the first day of the current month

FIRSTOFMONTH(-1) returns the first day of the previous month

FIRSTOFMONTH(0)-1 returns the last day of the previous month

Can't find a topic? Email us and we'll help you find what you need.