VBScript DateDiff Function
Complete VBScript Reference
The DateDiff function returns the number of intervals between two dates.
Syntax
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
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"
response.write(DateDiff("yyyy",fromDate,toDate) & "<br />")
response.write(DateDiff("q",fromDate,toDate) & "<br />")
response.write(DateDiff("m",fromDate,toDate) & "<br />")
response.write(DateDiff("y",fromDate,toDate) & "<br />")
response.write(DateDiff("d",fromDate,toDate) & "<br />")
response.write(DateDiff("w",fromDate,toDate) & "<br />")
response.write(DateDiff("ww",fromDate,toDate) & "<br />")
response.write(DateDiff("h",fromDate,toDate) & "<br />")
response.write(DateDiff("n",fromDate,toDate) & "<br />")
response.write(DateDiff("s",fromDate,toDate) & "<br />")
%>
fromDate="31-Jan-09 00:00:00"
toDate="31-Jan-10 23:59:00"
response.write(DateDiff("yyyy",fromDate,toDate) & "<br />")
response.write(DateDiff("q",fromDate,toDate) & "<br />")
response.write(DateDiff("m",fromDate,toDate) & "<br />")
response.write(DateDiff("y",fromDate,toDate) & "<br />")
response.write(DateDiff("d",fromDate,toDate) & "<br />")
response.write(DateDiff("w",fromDate,toDate) & "<br />")
response.write(DateDiff("ww",fromDate,toDate) & "<br />")
response.write(DateDiff("h",fromDate,toDate) & "<br />")
response.write(DateDiff("n",fromDate,toDate) & "<br />")
response.write(DateDiff("s",fromDate,toDate) & "<br />")
%>
The output of the code above will be:
1
4
12
365
365
52
53
8783
527039
31622340
Show Example »
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")
response.write(DateDiff("w",fromDate,toDate,vbMonday))
%>
fromDate=CDate("2009/12/31")
toDate=CDate("2012/12/31")
response.write(DateDiff("w",fromDate,toDate,vbMonday))
%>
The output of the code above will be:
156
Show Example »
Complete VBScript Reference
