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