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