[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

Subject: Re: using EXSLT {RE: date calculation from Excel 1900 Format}
From: Xiaocun Xu <xiaocunxu@xxxxxxxxx>
Date: Fri, 15 Jun 2001 05:56:35 -0700 (PDT)
excel xsl current date
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


Current Thread

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
Email
First Name
Last Name
Company
Subscribe in XML format
RSS 2.0
Atom 0.3
Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.