Inverse CTOS TTOS function

[Josh_Gervey_(Guest)]

Help!____Am looking to convert a date indicator stored in seconds since 1/1/1970 to a date format. The CTOS and TTOS seem to allow you to go from a date to seconds and I need to do the reverse. Has anyone come across this or created a function for this purpose?____Thanks.

[kfleming]

You could convert the seconds to days by dividing by 86400 (the number of seconds in a day) and then use the ADDDAYS() function to add that number of days to the start date of 01/01/1970.____Kathleen__R&R Support