MS Access Date Functions

Showing 5 of 20 records (Sample Data)

Function Description
Date Returns the current system date
DateAdd Adds a time/date interval to a date and then returns the date
DateDiff Returns the difference between two dates
DatePart Returns a specified part of a date (as an integer)
DateSerial Returns a date from the specified parts (year, month, and day values)

Notes

  • Last updated on January 27, 2020