IT. Expert System.

VBS

DateDiff()


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

1
4
12
365
365
52
53
8783
527039
31622340

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:

156

Miscellaneous Information

Supported in Version: 2.0


Content

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

License.
All information of this service is derived from the free sources and is provided solely in the form of quotations. This service provides information and interfaces solely for the familiarization (not ownership) and under the "as is" condition.
Copyright 2016 © ELTASK.COM. All rights reserved.
Site is optimized for mobile devices.
Downloads: 1002 / 96494555. Delta: 0.02119 с