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 Rhinorhino 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
- Status
Similar threads
- Locked
- Question