Date Functions VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Date Functions
  4. DateDiff returns the interval of time between two dates
Sub DateDiffExample()
  Debug.Print DateDiff("d", Now, "12/31/2010")
  ''Days until 12/31/2010
  Debug.Print DateDiff("m", Now, "12/31/2010")
  ''Months until 12/31/2010
  Debug.Print DateDiff("yyyy", Now, "12/31/2010")
  ''Years until 12/31/2010
  Debug.Print DateDiff("q", Now, "12/31/2010")
  ''Quarters until 12/31/2010
End Sub