Functions: dates

Below you will find the date-related functions, with a short description and an example model for each of them.

Function / Download Explanation
adddays Add a certain number of days to a date.
addmonths Add a certain number of months to a certain date.
addyears Add a certain number of years to a date.
age This function calculates the age of someone.
datetext This function writes out a date in text.
dayofweek Returns the day of the week in number format.
days Returns the day of the month in number format.
daysbetween Calculates the number of days between two dates.
firstofmonth This function calculates the first of the month in which the date occurs.
firstofyear Returns the first of the year in which the date occurs.
lastofmonth Returns the last of the month in which date occurs.
lastofquarter Returns the last date of the quarter in which the given date occurs.
months This function returns the month of the year in number format.
now Returns the date of today.
nowtime Returns the date of today and the current time.
weeksbetween Calculates the number of weeks between two dates.
years Returns the year in which the date occurs.