The formula I mentioned earlier appears to get it, to within one day. However, I was unaware of the LE services, which I'll now have to take a look at. For anyone that's interested, here's the spreadsheet test with error calculation based on Excel's built-in date stuff.
http://celestini.com/ibmmain/DateFormulaTest.xls At 10:31 AM 9/13/2005, Steve Comstock wrote: >Why not use LE callable services? Lilian timestamps are >64-bit double precision floating point numbers containing >the number of seconds that have elapsed since midnight >14 October 1492; they support dates and times up to the >year 10000. There are callable services to convert between >conventional date / time formats to Lilian. ================================================== Art Celestini Celestini Development Services Phone: 201-670-1674 Wyckoff, NJ ============= http://celestini.com ============= Mail sent to the "From" address used in this post will be rejected by our server. Please send off- list email to: ibmmain<at-sign>celestini<dot>com. ================================================== ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
