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