VBScript DateDiff function

Εκπαιδευτικός Οδηγός Συνάρτησης VBScript

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, the calculation method is date2 - date1.

When comparing years, regardless of the value below the month, when comparing months, regardless of the value below the day...... and so on.

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

Syntax

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

Required. The unit of time between date1 and date2 to be used in the calculation.

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 - Hour
  • n - Minute
  • s - Second
date1,date2 Required. Date expression. Two dates to be used in the calculation.
firstdayofweek

Optional. Defines the day of the week, that is, the day of the week.

The following values can be used:

  • 0 = vbUseSystemDayOfWeek - Using 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. Defines the first week of the year.

The following values can be used:

  • 0 = vbUseSystem - Using the NLS API settings for the regional language.
  • 1 = vbFirstJan1 - Starting from the week containing January 1st (default).
  • 2 = vbFirstFourDays - Starting from the first week of the year that has at least four days in the New Year.
  • 3 = vbFirstFullWeek - Αρχή της πρώτης πλήρους εβδομάδας του νέου έτους.

Παράδειγμα

Παράδειγμα 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"))

Έξοδος:

1/14/2002
11
351
505440

Παράδειγμα 2

Παρακαλώ σημειώστε ότι στο παρακάτω κώδικα, date1>date2:

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

Έξοδος:

1/14/2002
-351

Παράδειγμα 3

Πόσα εβδομάδες (αρχή την Δευτέρα),
Υπάρχουν
document.write(Date & "<br />")
document.write(DateDiff("w",Date,"10/10/2002",vbMonday))

Έξοδος:

1/14/2002
38

Εκπαιδευτικός Οδηγός Συνάρτησης VBScript