VBScript DateDiff Function

VBScript-Funktion Reference Handbook

Definition and Usage

The DateDiff function can return the number of intervals between two dates.

The DateDiff function is used to calculate the difference between two date-time values, with the calculation being date2 - date1.

If comparing years, disregard the values below the month; if comparing months, disregard the values below the day... and so on.

Note:The firstdayofweek parameter affects the calculations using the interval symbols 'w' and 'ww'.

Syntax

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

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

The following values can be used:

  • yyyy - Year
  • q - Quarter
  • m - Month
  • y - Day of the year
  • d - Day
  • w - Day of the week
  • ww - Week
  • h - Hours
  • n - Minutes
  • s - Seconds
date1,date2 Required. Date expression. Two dates to be used in the calculation.
firstdayofweek

Optional. Specifies the number of days in a week, i.e., the day of the week.

The following values can be used:

  • 0 = vbUseSystemDayOfWeek - Use the NLS API settings for the regional language.
  • 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.

The following values can be used:

  • 0 = vbUseSystem - Use the NLS API settings for the regional language.
  • 1 = vbFirstJan1 - From the week containing January 1st (default).
  • 2 = vbFirstFourDays - From the first week of the year that has at least four days starting in the New Year.
  • 3 = vbFirstFullWeek - Der Wert wird durch den Beginn der ersten vollständigen Woche im neuen Jahr bestimmt.

Beispiel

Beispiel 1

document.write(Date & "<br />")
document.write(DateDiff("m",Date,"12/31/2002") & "<br />")
document.write(DateDiff("d",Date,"12/31/2002") & "<br />")
document.write(DateDiff("n",Date,"12/31/2002"))

Ausgabe:

1/14/2002
11
351
505440

Beispiel 2

Bitte beachten Sie im folgenden Code, dass date1>date2:

document.write(Date & "<br />")
document.write(DateDiff("d","12/31/2002",Date))

Ausgabe:

1/14/2002
-351

Beispiel 3

Wie viele Wochen (Start am Montag),
bleiben zwischen dem aktuellen Datum und 10/10/2002
document.write(Date & "<br />")
document.write(DateDiff("w",Date,"10/10/2002",vbMonday))

Ausgabe:

1/14/2002
38

VBScript-Funktion Reference Handbook