Excel & arsdate

[zancanaro]

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.

[Justin Derrick]

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.

[zancanaro]

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.

[zancanaro]

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