VBScript Tutorial

VB HOME
VB Introduction
VB How to
VB Where to
VB Variables
VB Procedures
VB Conditional
VB Looping
VB Summary

VBScript Examples

VB Examples

VBScript References

VB Functions
VB Keywords

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: 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:

The output of the code above will be:

1
4
12
365
365
52
53
8783
527039
31622340

Try it yourself »

Example 2

How many weeks (start on Monday),
between December 31 2009 and December 31 2012: