For the purposes of the PROMOTIC system, it is more usefull to use the method: Pm.DateDiff.
n = DateDiff(interval, date1, date2[, firstdayofweek[, firstweekofyear]])
interval | (String) Specifies the interval (type of time range) used to calculate the difference between date1 and date2 "yyyy" - year "q" - quarter "m" - month "y" - day of year "d" - day "w" - day of the week "ww" - week of year "h" - hour "n" - minute "s" - second |
---|---|
date1 | (Date) First date in the calculation |
date2 | (Date) Second date in the calculation |
firstdayofweek | [optional] (Integer) Specifies the first day of the week. If not set, then Sunday is assumed (see VBScript Date and Time constants). This argument affects calculations that use the "w" and "ww" interval symbols. |
firstweekofyear | [optional] (Integer) Specifies the first week of year. If not set, then the first week is assumed to be the week in which 1st January occurs (see VBScript Date and Time constants). |
To calculate the number of days between date1 and date2, can be used day of year ("y") or day ("d").
Dim s
s = "The number of days from today: " & DateDiff("d", Now(), tDate)