The DateDiff function returns the number of intervals between two dates.
Parameter | Description |
---|---|
interval | Required. The interval you want to use to calculate the
differences between date1 and date2 Can take the following values:
|
date1,date2 | Required. Date expressions. Two dates you want to use in the calculation |
firstdayofweek | Optional. Specifies the day of the week. Can take the following values:
|
firstweekofyear | Optional. Specifies the first week of the year. Can take the following values:
|
The difference between January 31 2009, and January 31 2010:
The output of the code above will be:
How many weeks (start on Monday),
between December 31 2009 and December 31 2012:
The output of the code above will be: