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. |