Subject: [xsl] date calculation from Excel 1900 Format From: Xiaocun Xu <xiaocunxu@xxxxxxxxx> Date: Mon, 11 Jun 2001 11:50:22 -0700 (PDT) |
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
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
RE: [xsl] Multiple Selects Revisite, Heather Lindsay | Thread | Re: [xsl] date calculation from Exc, Goetz Bock |
Re: [xsl] checking if an attribute , Oskar Werewka | Date | RE: [xsl] Sorting date in xsl, Hahn, Kimberly |
Month |