OnDemand User Group

Support Forums => Documentation => Topic started by: zancanaro on October 06, 2010, 08:02:16 AM

Title: Excel & arsdate
Post by: zancanaro on October 06, 2010, 08:02:16 AM

Hi all,

Does anyone own the true valor to convert a xxx.arssag  DB_EXP_DATE arsdate to an Excel date formatted ( 3/14/2001) column ?

Thank's a lot.

Title: Re: Excel & arsdate
Post by: Justin Derrick on October 06, 2010, 11:15:47 AM

Of course, IBM's official answer to this question is that querying arsdate is the ONLY true method of calculating the 'arsdate' value, which is a good answer when it's feasible.

The basic function is number of seconds since midnight January 1st, 1970, divided by 86400 (ie, the number of seconds in a day). 
You must perform your own time-zone calculations, and there is no accommodation for leap-seconds as far as I know.

Good luck -- and please share your solution!

-JD.

Title: Re: Excel & arsdate
Post by: zancanaro on October 11, 2010, 03:21:57 AM

Hi Justin ,

The true Excel's function is :
=(A1)+25568
Where A1 is the arsdate's value.  Of course, the Excel calculated cellul in format date......
Best regards, Stephane.

Title: Re: Excel & arsdate
Post by: zancanaro on October 16, 2013, 01:34:47 AM

And for times in seconds, the Excel value is :  =(A1  /  86400)  +  25569   //////  Without GMT range .