Skip to main content
Video tutorials
TimeTonic GPT
Log in
EN
FR
Français
EN
English
Navigation
Video tutorials
TimeTonic GPT
Log in
Language
FR
EN
Account
Search
Let us guide you!
TimeTonic Help Center
Formulas
Functions
Date functions
Date functions
MIN_DATE_ELEMENTS() : find the earliest date (among linked dates)
MAX_DATE_ELEMENTS() : find the latest date (among linked dates)
DATE_ADD() : add or subtract days from a date
DATE_ADDNB() : add a number of days (number column) to a date
DATEHOUR_ADD() : add hours to a date and time
DATEMINUTE_ADD() : add minutes to a date and time
TIME() : extract the time from a date and time
TIME_DELTA() : calculate a gap in minutes between two times
HOUR_DELTA() : add up hours (calculate a gap in hours)
TODAY() : display today's date
DAY() : extract the day of the month from a date
DAY_IN_WEEK() : extract the day-of-week number
DAY_DELTA() : count calendar days between two dates
DAY_OPEN_DELTA() : count business days between two dates (excluding weekends)
DAY_DELTA_TODAY() : count the days between today and a date
WEEK() : extract the week number of a date
WEEK_ADD() : add weeks to a date
WEEK_DELTA() : count the weeks between two dates
WEEK_DELTA_TODAY() : count the weeks between today and a date
MONTH() : extract the month number from a date
MONTH_DELTA() : count the months between two dates
MONTH_ADD() : add months to a date
QUARTER() : extract the quarter from a date
YEAR() : extract the year from a date
YEAR_ADD() : add years to a date
YEAR_WEEK() : display the year and week of a date
YEAR_MONTH() : display the year and month of a date
YEAR_QUARTER() : display the year and quarter of a date
YEAR_DELTA_TODAY() : calculate an age from a birth date