Does anybody know how to convert EPOC date/time to True Date 2

[MrHelpMe]

Hello,

Using Crystal Reports 8.0 and tapping into Remedy database, does anybody know how to convert EPOC Date to true data. Currently Remedy spits out a number 1,065,472, 961. I have no idea how to interpret this. Your assistance is appreciated. Thanks.

 

[mbarron]

You can do this using the dateadd function.

dateadd("s",{your.field},date(1970,1,1))


Mike

 

[synapsevampire]

Epoch is number of seconds since 1/1/1970.

Try:

dateadd("S",{table.field},cdate(1970,1,1))

 

[MrHelpMe]

Thanks guys.

Just going forward with this, does this account for Daylight savings time and the fact that we are 5 hours behind the International Date Line. This is because I live in Eastern Canada where I have to take these factors into account.

 

[bdjb]

Hi Salvator,
I had the same issue, and found a free product at

http://www.elegantsp.com/crystalfunc.html

that creates a function within Crystal to do the Epoch date conversions. It gives several different methods, such as to date, to datetime, etc.

Bob

What happens if you get scared half to death twice?

Bob