Returns the number of intervals between two dates.

`n = `**DateDiff**(interval, date1, date2[, firstdayofweek[, firstweekofyear]])

interval | (String) Text string that is the interval you want to use to calculate the differences 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").

Detects the number of days between a given date tDate and today

VBScriptSelect and copy to clipboard

Dim s

s = "The number of days from today: " & DateDiff("d", Now(), tDate)

Send page remarkContact responsible person

Navigation:

- VBScript

- Abs

- And

- Array

- Asc

- Atn

- CBool

- CByte

- CDate

- CDbl

- CInt

- CLng

- Cos

- CSng

- CStr

- Date

- DateAdd

- DateDiff

- DatePart

- Day

- Dim

- Eqv

- Erase

- Eval

- Exit

- Exp

- Filter

- Fix

- Hex

- Hour

- Chr

- If

- Imp

- InputBox

- InStr

- InstrRev

- Int

- Is

- IsArray

- IsDate

- IsEmpty

- IsNull

- IsObject

- Join

- LBound

- LCase

- Left

- Len

- Log

- LTrim

- Mid

- Minute

- Mod

- Month

- MsgBox

- Not

- Now

- Oct

- On Error

- Or

- ReDim

- Rem

- Replace

- RGB

- Right

- Rnd

- Round

- RTrim

- Second

- Set

- Sgn

- Sin

- Space

- Split

- Sqr

- StrComp

- String

- Tan

- Time

- Trim

- TypeName

- UBound

- UCase

- VarType

- Weekday

- Xor

- Year