[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] Re: using EXSLT {RE: date calculation from Excel 1900
Hi, Jeni: Thanks for all your help. Following your advices, I was able to convert the date/time from Excel 1900 format precisely in XSL. > > C. when import just the templates: > > <xsl:import href="date.add.template.xsl"/> > > <xsl:import href="date.duration.template.xsl" /> > > Uses xsl:call-template and run Saxon, it works and > > outputs "2002-01-03T01:00:00". > > Cool. Note, as I said, that the date is off by 2 > days, because Excel > starts the count at 1 and because it thinks that > 1900 is a leap year. As always, this was right on the spot, as well as your previous comment about the need to use translate() to get the format "2002-01-03 01:00:00". > > The good news is I found a way that works. The > questions I have > > though is, how to get approach B to work? > > Come over to the EXSLT list > (http://www.exslt.org/list) and we'll see > if we can work out what's going wrong. Thanks for the invite. I will do exactly that. Thanks again, Xiaocun __________________________________________________ Do You Yahoo!? Spot the hottest trends in music, movies, and more. http://buzz.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
|