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.
dateinwords	Returns the date in the specified language.
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.
minutesbetween	Returns the number of minutes between two dates.
monthcalendardiff	Returns the number of whole months between two dates.
months	This function returns the month of the year in number format.
monthsbetween	Returns the number of whole months between two dates.
now	Returns the date of today.
nowtime	Returns the date of today and the current time.
texttodate	Return text as a date according to the specified format.
timestamp	Return the current timestamp with high precision.
weeksbetween	Calculates the number of weeks between two dates.
weeksoftheyear	Returns the week of the year represented by the date.
years	Returns the year in which the date occurs.