VBScript DateDiff Function

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: yyyy - Year q - Quarter m - Month y - Day of year d - Day w - Weekday ww - Week of year h - Hour n - Minute s - Second
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: 0 = vbUseSystemDayOfWeek - Use National Language Support (NLS) API setting 1 = vbSunday - Sunday (default) 2 = vbMonday - Monday 3 = vbTuesday - Tuesday 4 = vbWednesday - Wednesday 5 = vbThursday - Thursday 6 = vbFriday - Friday 7 = vbSaturday - Saturday
firstweekofyear	Optional. Specifies the first week of the year. Can take the following values: 0 = vbUseSystem - Use National Language Support (NLS) API setting 1 = vbFirstJan1 - Start with the week in which January 1 occurs (default) 2 = vbFirstFourDays - Start with the week that has at least four days in the new year 3 = vbFirstFullWeek - Start with the first full week of the new year

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) & " ")
response.write(DateDiff("q",fromDate,toDate) & " ")
response.write(DateDiff("m",fromDate,toDate) & " ")
response.write(DateDiff("y",fromDate,toDate) & " ")
response.write(DateDiff("d",fromDate,toDate) & " ")
response.write(DateDiff("w",fromDate,toDate) & " ")
response.write(DateDiff("ww",fromDate,toDate) & " ")
response.write(DateDiff("h",fromDate,toDate) & " ")
response.write(DateDiff("n",fromDate,toDate) & " ")
response.write(DateDiff("s",fromDate,toDate) & " ")

%>

The output of the code above will be:

1
4
12
365
365
52
53
8783
527039
31622340

Show Example »