Date Functions

DayOfMonth(x)

This function returns the day of the month for a given date (a number from 1 to 31).Example:DayOfMonth("date_of_loss") = Accident day
DayOfYear(x)

This function returns the day of the year for a given date (a number from 1 to 366).Example:DAYOFYEAR(“policy_date”)
MONTHOFYEAR(x)

This function returns the month of the year for a given date (a number from 1 to 12).Example:monthOfYear("date_of_loss") = Accident month
MonthOfYearBracket(x)

This function returns the month and the year for a given date (a number with the format YYYYMM).Example:MonthOfYearBracket('31/12/2022')=202212
YEAROF(x)

This function returns the year for a given date (example 2019).