Date and Time Functions


Date functions are functions that manipulate fields set to date data type and return date-related information.

Common Date and Time Functions

  • NOW()
    • uses the computer system time to tell the current date and time of a calculation
    • using NOW and another date returns the number of days between the dates
  • TODAY()
    • gives you the date but not the time
  • DATEDIFF()
    • used to calculate the amount of days between two dates: a start date and an end date
  • NETWORKDAYS()
    • calculates how many business days exist between a start and end date
  • WEEKDAY([StartDate])
    • returns a number 1 through 7 to designate the day of the week
  • WEEKNUM([StartDate])
    • returns the number of the week of that year as 1 through 52
  • MONTH([StartDate])
    • returns a 1–12 to designate the month of the year