Thread: Date Diff Help
View Single Post
  #1 (permalink)  
Old Aug 22nd, 2003, 09:42
kinjiro kinjiro is offline
Junior Member
Join Date: Aug 2003
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Date Diff Help

This may have been answered, but my problem is pretty specific....

I know to use the DateDiff function to get the difference between two times, but my problem lies with times falling on the day in question and then the following day

ie 5:48pm - 1:12am

this gives me negative values for hours and minutes...

is there anyway I can use the function to automatically detect that we have gone over hte midnight barrier and display the correct figures?

Cheers in advance...

Neil