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