Date Functions
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).