Vb Script Tutorial

10.4 DateAdd
The DateAdd function returns a date to which a specified time interval has been added.
Syntax DateAdd(interval,number,date)
Parameter
Description
interval
Required. The interval you want to add
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
number
Required. The number of interval you want to add. Can either be positive, for dates in the future, or negative, for dates in the past
date
Required. Variant or literal representing the date to which interval is added
Example 1
'Add one month to January 31, 2000document.write(DateAdd("m",1,"31-Jan-00"))Output:2/29/2000
Example 2
'Add one month to January 31, 2001document.write(DateAdd("m",1,"31-Jan-01"))Output:2/28/2001
10.5 DateDiff
The DateDiff function returns the number of intervals between two dates.
Syntax
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 = 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 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
Example 1
document.write(Date & "
")document.write(DateDiff("m",Date,"12/31/2002") & "
")document.write(DateDiff("d",Date,"12/31/2002") & "
")document.write(DateDiff("n",Date,"12/31/2002"))Output:1/14/200211351505440