This is the mail archive of the
xsl-list@mulberrytech.com
mailing list .
date calculation from Excel 1900 Format
- To: xsl-list at lists dot mulberrytech dot com
- Subject: [xsl] date calculation from Excel 1900 Format
- From: Xiaocun Xu <xiaocunxu at yahoo dot com>
- Date: Mon, 11 Jun 2001 11:50:22 -0700 (PDT)
- Reply-To: xsl-list at lists dot mulberrytech dot com
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