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

<%
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 »

## 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))
%>

The output of the code above will be:

156
Show Example »

Complete VBScript Reference

### WEB HOSTING

UK Reseller Hosting

### WEB BUILDING

FREE Website BUILDER Free HTML5 Templates

### W3SCHOOLS EXAMS

HTML, CSS, JavaScript, PHP, jQuery, XML, and ASP Certifications

### SHARE THIS PAGE

### Color Picker

### HTML/CSS

HTML Tutorial HTML5 Tutorial CSS Tutorial CSS3 Tutorial Bootstrap Tutorial

### JavaScript

JavaScript Tutorial jQuery Tutorial jQuery Mobile Tutorial AngularJS Tutorial AJAX Tutorial JSON Tutorial

### Graphics

Canvas Tutorial SVG Tutorial Google Maps Tutorial

### Server Side

SQL Tutorial PHP Tutorial ASP Tutorial ASP.NET Tutorial VBScript Tutorial AppML Tutorial

### Web

Web Building Web Statistics Web Certification

### XML

XML Tutorial DTD Tutorial Schema Tutorial XML DOM Tutorial XPath Tutorial XSLT Tutorial XQuery Tutorial XSL-FO Tutorial RSS Tutorial WSDL Tutorial

### HTML/CSS

HTML Tag Reference HTML Event Reference HTML Color Reference CSS 1,2,3 Reference Bootstrap Reference

### JavaScript

JavaScript Reference HTML DOM Reference jQuery Reference jQuery Mobile Reference Google Maps Reference

### Server Side

PHP Reference SQL Reference ASP Reference VBScript Reference Razor Reference ASP.NET Reference

### XML

XML DOM Reference XSLT Reference XSL-FO Reference XPath Reference XQuery Reference Schema Reference RSS Reference SVG Reference

### HTML Charsets

HTML Character Sets HTML ASCII HTML ANSI HTML Windows-1252 HTML ISO-8859-1 HTML Symbols HTML UTF-8

### HTML/CSS

HTML Examples CSS Examples

### Browser Scripting

JavaScript Examples HTML DOM Examples jQuery Examples jQuery Mobile Examples AngularJS Examples AJAX Examples

### Server Scripting

PHP Examples ASP Examples VBScript Examples Razor Examples .NET Examples

### XML Languages

XML Examples DTD Examples XML DOM Examples XSL Examples XSLT Examples XPath Examples XQuery Examples Schema Examples RSS Examples SVG Examples