date time seconds formula
date time seconds formula
(OP)
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.
RE: date time seconds formula
How about:
DateTimeValue(1970,1,1,0,0,0) + {field} / (24*60*60)
Ken Hamady
http://www.kenhamady.com/
On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.