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 Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
epoch time conversion
Thanks very much...I had just implemented that same formula and it worked...forgot all about the GMT issue!!! I'm not sure about the daylight savings time though...if the time is recorded based on the OS time, should this not be address? I'm running some tests now to see the outcome, I'm...- jtaker
- Post #6
- Forum: Business Objects: Crystal Reports 1 Formulas
-
epoch time conversion
Thanks mbarron. I modified the formula to try yours which sounds logical (although I'd still like to know why this basic formula doesn't do what it says it does!) but if you can believe it, it actually subtracts 6 hours and not 5. This is a little insane!! Any other thoughts though would be...- jtaker
- Post #3
- Forum: Business Objects: Crystal Reports 1 Formulas
-
epoch time conversion
Good day, I need to know how to convert epoch time to a normal readable string. I've tried using the following formula but all my dates are consistently off by 5 hours. here is the formula I used: dateadd("s",{HPD_HELP_DESK.REPORTED_DATE},date(1970,1,1)) Any help would be greatly appreciated...- jtaker
- Thread
- Replies: 5
- Forum: Business Objects: Crystal Reports 1 Formulas
