This is the mail archive of the xsl-list@mulberrytech.com mailing list .


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]

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


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]