|
[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] date calculation from Excel 1900 Format
Hi, During my conversion from Excel to XML, I needed to convert dates. Excel stores date in so called "1900 format", which is the number of days since 1/1/1900 in decimal format, e.g. 37257.041667 for 1/1/2002 1AM. I need to convert this back to YYYY-MM-DD HH:MM:SS format when I convert the Excel into XML. Has anyone did date conversion calculation, esp. Excel 1900 format, with XSL? Much thanks, Xiaocun __________________________________________________ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|

Cart








