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: 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 = vbUseSystem DayOfWeek - 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

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

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:

Miscellaneous Information

Supported in Version:	2.0

IT. Expert System.

VBS

DateDiff()

Description

Examples

Example 1

Example 2

Miscellaneous Information

Android Reference

Java basics

Java Enterprise Edition (EE)

Java Standard Edition (SE)

SQL

HTML

PHP

CSS

Java Script

MYSQL

JQUERY

VBS

REGEX

C

C++

C#

Design patterns

RFC (standard status)

RFC (proposed standard status)

RFC (draft standard status)

RFC (informational status)

RFC (experimental status)

RFC (best current practice status)

RFC (historic status)

RFC (unknown status)

IT dictionary