THE WORLD'S LARGEST WEB DEVELOPER SITE

MS Access DateDiff() Function

❮ MS Access Functions

Example

Return the difference between two dates, in years:

SELECT DateDiff("yyyy", #13/01/1998#, #09/05/2017#);
Try it Yourself »

Definition and Usage

The DateDiff() function returns the difference between two dates.

Syntax

DateDiff(datepart, date1, date2, firstdayofweek, firstweekofyear)

Parameter Values

Parameter Description
datepart Required. The part to return. Can be one of the following values:
  • yyyy = Year
  • q = Quarter
  • m = month
  • y = Day of the year
  • d = Day
  • w = Weekday
  • ww = Week
  • h = hour
  • n = Minute
  • s = Second
date1 and date2 Required. The two dates to calculate the difference between
firstdayofweek Optional. Specifies the first day of the week. Can be one of the following values:
  • 0 = Use the NLS API setting
  • 1 = Sunday (this is default)
  • 2 = Monday
  • 3 = Tuesday
  • 4 = Wednesday
  • 5 = Thursday
  • 6 = Friday
  • 7 = Saturday
firstdayofyear Optional. Specifies the first week of the year. Can be one of the following values:
  • 0 = Use the NLS API setting
  • 1 = Use the first week that includes Jan 1st (default)
  • 2 = Use the first week in the year that has at least 4 days
  • 3 = Use the first full week of the year

Technical Details

Works in: From Access 2000

More Examples

Example

Return the difference between two dates, in months:

SELECT DateDiff("m", #13/01/1998#, #09/05/2017#);
Try it Yourself »

Example

Return the difference between a specified date and today's date, in days:

SELECT DateDiff("d", #13/01/1998#, Date());
Try it Yourself »

❮ MS Access Functions