[xsl] date calculation from Excel 1900 Format

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