VBScript DateDiffFunction

VBScript 参考手册Complete VBScript Reference

The DateDiff function returns the number of time intervals between two dates.

Syntax

DateDiff(interval,date1,date2[,firstdayofweek[,firstweekofyear]])

Parameters Description
interval Required. The unit used to calculate the time interval between date1 and date2.

Can take the following values:

  • yyyy - Year
  • q - Quarter
  • m - Month
  • y - Day of the year
  • d - Day
  • w - Day of the week
  • ww - Week of the year
  • h - Hour
  • n - Minute
  • s - Second
date1,date2 Required. Date expressions. The two dates to be used 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 containing January 1 (default)
  • 2 = vbFirstFourDays - Start with the first 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:

<script type="text/vbscript">

fromDate="31-Jan-09 00:00:00"
toDate="31-Jan-10 23:59:00"
document.write(DateDiff("yyyy",fromDate,toDate) & "<br />")
document.write(DateDiff("q",fromDate,toDate) & "<br />")
document.write(DateDiff("m",fromDate,toDate) & "<br />")
document.write(DateDiff("y",fromDate,toDate) & "<br />")
document.write(DateDiff("d",fromDate,toDate) & "<br />")
document.write(DateDiff("w",fromDate,toDate) & "<br />")
document.write(DateDiff("ww",fromDate,toDate) & "<br />")
document.write(DateDiff("h",fromDate,toDate) & "<br />")
document.write(DateDiff("n",fromDate,toDate) & "<br />")
document.write(DateDiff("s",fromDate,toDate) & "<br />")

</script>

The output result of the above example:

1
4
12
365
365
52
53
8783
527039
31622340

Try it yourself »

Example 2

How many weeks are there between December 31, 2009 and December 31, 2012 (starting on Monday):

<script type="text/vbscript">

fromDate=CDate("2009/12/31")
toDate=CDate("2012/12/31")
document.write(DateDiff("w",fromDate,toDate,vbMonday))

</script>

The output result of the above example:

156

Try it yourself »

VBScript 参考手册Complete VBScript Reference Other extensions