How can i convert a unix date to a regular date

[Jamrock97]

I am using CR XI R2 and connected to fileNet which stores data on Oracle on AIX .. etc.. when creating a report i get the Unix date 14302.00, i need to convert it to the date yy/mm/dd..looking up the conversion on google, it translate the number to 02/27/2009, How can i calculate this in my report. Please help. i have tried this formula but it gives me a date of 02/26/1939 which is wrong.. please help

If IsDate({DOCTABABOCOLD.F_ENTRYDATE}) Then
CDate({DOCTABABOCOLD.F_ENTRYDATE})
Else
CDate(0,0,0)

 

[IanWaterman]

There are plenty of posts on this subject! Use a formula to convert to a date

The latest is from Kskid

dateadd("s",{table.unixnumber},datetime(1970,1,1,0,0,0))


Ian