Page 1 of 1

Inverse CTOS TTOS function

Posted: Mon Dec 04, 2006 1:09 pm
by 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.

=> RE: Inverse CTOS TTOS function

Posted: Tue Dec 12, 2006 10:03 am
by 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