Description
The DateDiff() function returns the number of intervals between two dates.
This function has the form:
DateDiff(interval,date1,date2 [,firstdayofweek [,firstweekofyear]])
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:
|
Examples
The following examples show the basic use of this function:
Example 1
The difference between January 31 2009, and January 31 2010:
fromDate = "31-Jan-09 00:00:00"
toDate = "31-Jan-10 23:59:00"
Msgbox(DateDiff("yyyy",fromDate,toDate))
Msgbox(DateDiff("q",fromD,toDate))
Msgbox(DateDiff("m",fromDate,toDate))
Msgbox(DateDiff("y",fromDate,toDate))
Msgbox(DateDiff("d",fromDate,toDate))
Msgbox(DateDiff("w",fromDate,toDate))
Msgbox(DateDiff("ww",fromDate,toDate))
Msgbox(DateDiff("h",fromDate,toDate))
Msgbox(DateDiff("n",fromDate,toDate))
Msgbox(DateDiff("s",fromDate,toDate))
This produces the following result (each line in a separate pop-up message box):
1
4
12
365
365
52
53
8783
527039
31622340
Example 2
How many weeks (start on Monday),
between December 31 2009 and December 31 2012:
fromDate = CDate("2009/12/31")
toDate = CDate("2012/12/31")
Msgbox(DateDiff("w",fromDate,toDate,vbMonday))
This produces the following result:
156
Miscellaneous Information
Supported in Version: | 2.0 |
---|