clientuser
Programmer
what is the suggested function to calculate the difference in time for the following format:
3/1/2004 8:11:25 AM
3/1/2004 8:11:25 AM
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
date diff for long date/times 1
- Thread starter clientuser
- Start date
- Status
-
1
- #2
Time and/or date formats don't have much to do with calculations. All "Date" type variables are stored as doubles with the date before the decimal place and the time after it. To do date/time related calculations you can use DateDiff, DateDiff, DateSerial or any of the other date calculation routines without regard to how you are displaying those values.
- Status
