Subject: RE: Finding total hours between two dates and keeping a running total
From: "Michael Kay" <mhk@xxxxxxxxx>
Date: Tue, 18 Nov 2003 20:19:12 -0000
|
XSLT 2.0 / XPath 2.0 has a wide range of functions for date arithmetic
and formatting.
If you need an XSLT 1.0 solution you might look at the date/time
libraries in EXSLT (www.exslt.org)
Michael Kay
> -----Original Message-----
> From: owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx
> [mailto:owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx] On Behalf Of
> kakridge@xxxxxxxxxxxxx
> Sent: 18 November 2003 18:03
> To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
> Subject: Finding total hours between two dates and
> keeping a running total
>
>
> I currently have XML like this portion:
>
> <ArrayOfReservation>
> <Reservation>
> <StartDate>2003-11-13T09:00:00.0000000-05:00</StartDate>
> <EndDate>2003-11-13T17:00:00.0000000-05:00</EndDate>
> </Reservation>
> <Reservation>
> ...
> ...
> </Reservation>
> ...
> ...
> ...
> </ArrayOfReservation>
>
> How can I:
>
> 1. Display 9:00 AM and 5:00 PM instead of 09:00 and 17:00
>
> 2. Get the total number of hours between the two times( problems arise
> for me when I have multi day events).
>
> 3. Display the total number of hours for all
> reservations(this is most important, and I am completely
> stumped on this one. I imagine it has something to do with a
> variable, but I am a novice and keep getting variable scope errors).
>
>
> Thank you in advance for your help.
>
>
> -Kenny Akridge
>
>
> XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
>
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
|