XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext Topic
Posttop
Ron BernardSubject: Need help comparing dates in xsl
Author: Ron Bernard
Date: 12 Jul 2010 10:56 AM
I have xml in the following format:
<data jsxid="jsxroot">
<record group="CUSTOMER" id="89" text="blah blah blah" type="blah" code="W" creationDateTime="Mon Jul 12 09:40:33 CDT 2010"/>
<record group="CUSTOMER" id="90" text="blah blah blah" type="blah" code="W" impactDateTime="Mon Jul 12 14:00:33 CDT 2010"/>
<record group="CUSTOMER" id="91" text="blah blah blah" type="blah" code="W" impactDateTime="Mon Jul 12 21:20:33 CDT 2010"/>
<record group="CUSTOMER" id="92" text="blah blah blah" type="blah" code="W" impactDateTime="Mon Jul 12 23:00:33 CDT 2010"/>
</data>

Given that the current day is Jul 12 and using a xsl stylesheet version 1.0, I would like to be able to filter records where the impactDateTime attribute is a parameter variable (hours) greater than the current dateTime.

For example, if the current dateTime is Mon Jul 12 13:10:23 CDT 2010, and I only want to see records that will impact me (based on the impactDateTime attribute) in the next two hours then the filter should return me:

<record group="CUSTOMER" id="90" text="blah blah blah" type="blah" code="W" impactDateTime="Thu Jul 8 14:00:33 CDT 2010"/>


Is this possible? Any help given would be greatly appreciated.

Thanks
rb123

 
Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.