I need help with a formula to convert a number field to a datetime field. This particular field stores seconds from 01/01/1970 00:00:00 I am having a brain fart and cannot remeber all of the rules for leap years and so forth, and someone mentioned needing to add 1 second every 11 years? any help would be appriciated.
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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
date time seconds formula
- Thread starter stinker
- Start date
I hope you don't have to do that.
How about:
DateTimeValue(1970,1,1,0,0,0) + {field} / (24*60*60) Ken Hamady
On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.
How about:
DateTimeValue(1970,1,1,0,0,0) + {field} / (24*60*60) Ken Hamady
On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.
- Status
Similar threads
- Question