FIRST_DAY_OF_MONTH

Calculates the date that corresponds to the first day of month of the provided date

FIRST_DAY_OF_MONTH (date)

Attribute of the Date type or date constant or calculation producing a date

Date: the first day of the month of the given date.

IF FIRST_DAY_OF_MONTH (Account.OpeningDate) = 01/10/2004 THEN ...