MS Access DateDiff() Function

Return the difference between two dates, in years:

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

Definition and Usage

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

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

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

Works in:	From Access 2000

Return the difference between two dates, in months:

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

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

SELECT DateDiff("d", #13/01/1998#, Date());