Loading lesson path
Concept visual
Start at both ends
Return the difference between two dates, in years:
SELECT DateDiff("yyyy", #13/01/1998#, #09/05/2017#);The DateDiff() function returns the difference between two dates.
datepart, date1, date2, firstdayofweek, firstweekofyear )
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:
Formula
0 = Use the NLS API setting
1 = Sunday (this is default)
2 = Monday
3 = Tuesday
4 = Wednesday
5 = Thursday
6 = Friday
7 = Saturday firstdayofyearOptional. Specifies the first week of the year. Can be one of the following values:
Formula
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 yearReturn 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());❮ MS Access Functions