Description: Returns the number of
intervals between two dates/times.
Interval :
yyyy
year
q
quarter
m
month
d
day
ww
week
w
weekday
y
day of year
h
hour
n
minute
s
second
Date1 :
First date and time to consider
Date2 :
Second date and time to compare with.
FirstDayofWeek :
Optional. This constant specifies which day is
considered to be the start of the week. 0 is the system
default, 1 is Sunday, 2 is Monday, 3 is Tuesday, and so
on.
FirstWeekOfYear :
Optional. This constant specifies the first week
of the year. If not specified the first week of the year is
considered the week of January the 1st. 0 is the system
default, 1 is week of January the 1st, 2 starts with the week
that has at least 4 days, 3 starts the year with the first
full week.
Example:
Compute the number of
years between the two dates
given. =DateDiff("yyyy","01/01/2000","01/01/2003")
Compute the number of quarters
between the two dates
given. =DateDiff("q","01/01/2000","01/07/2000")
Compute the number of months
between the two dates
given. =DateDiff("m","01/01/2000","01/07/2000")
Compute the number of days between the
two dates
given. =DateDiff("d","01/01/2000","10/01/2000")
Compute the number of weeks between the two dates
given. =DateDiff("ww","01/01/2000","01/02/2000")
Compute the number of hours
between the two times
given. =DateDiff("h","12:05:30","15:30:10")
Compute the number of minutes
between the two times
given. =DateDiff("n","12:05:30","12:09:35")
Compute the number of seconds
between the two times
given. =DateDiff("s","12:05:30","12:05:35")
