This article provides details on our Date Functions that are available for use with the Equation Field.





The DAYOFMONTH function generates the day number given a date value. 





The DAYOFWEEK function generates a numeric representation for the day of the week that the given date falls on. The generated value will be a number from 1-7 where 1 is Sunday and 7 is Saturday.





The DAYOFYEAR function generates a numeric representation for the day of the year which the given date falls on. The generated value will be a number from 1-365.





The LAST_DAY function generates the last date of the month of the given date. The generated value will be a date.





The YEAR function generates the year of the given date. The output will be a single numeric representation of the year value.





The MONTH function generates the month of the given date. The output will be a single numeric representation of the month value.





The MONTHNAME function generates the name of the month of the given date. The output will be a text representation of the month value.





The NOW function generates the current time. This function, unlike the other Date Functions, is not to be used with any fields as input. The value is saved upon record creation and updated upon saving any type of edit.





The WEEKOFYEAR function generates the week number that the given date falls within. The output will be a single numeric representation of the week.