Date/Time Calculations (Possibly DateDiff)

[abhodges]

I am trying (without much luck) to calculate the elapsed time in days and hours between two date fields. Anyone care to help?

Oh ya, I know almost nothing about VBScipt!

Brusifer

 

[Cheech]

DateDiff(h, date1, date2) should do the trick The secret of life is honesty and fair dealing. If you can fake that, you've got it made.
Groucho Marx (1895-1977)

 

[abhodges]

Sorry, should have also stated that I am working with long date formats, including time. eg. Wednesday August 28, 2002 6:14pm. DateDiff doesn't seem to work when the time is included.

 

[JMcAllister]

DateDiff should work with long dates... Try using IsDate to verify that the date is being passed correctly.

If Not IsDate(dtNow) Then
  MsgBox "dtNow: " & dtNow & " is not a valid date."
End If

If Not IsDate(dtThen) Then
  MsgBox "dtThen: " & dtThen & " is not a valid date."
End If

lElapsed = DateDiff(h, dtThen, dtNow)