SSDN - select items based on the date

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9

Curtis Bennett

Subject: select items based on the date
Author: Curtis Bennett
Date: 09 Dec 2005 02:45 PM
Originally Posted: 09 Dec 2005 02:41 PM

I am using an rss feed on my site and I would like to only show items that are no more than 5 days old.<br> <br> So, if today is 12/9/05 then I don't want to show any articles older than 12/4/05. Can this be done with XSLT? The date comes in like this: Wed, 07 Dec 2005 01:42:52 -0700

Minollo I.

Subject: select items based on the date
Author: Minollo I.
Date: 09 Dec 2005 03:16 PM

Curtis,
XSLT 1.0 doesn't have any specific knowledge about dates or time; the EXSLT library provides some functionality that may be enough for what you are looking for: http://www.exslt.org/date/index.html

XSLT 2.0 recognizes the XML Schema date/time types (like xs:date and xs:dateTime - http://www.w3.org/TR/xmlschema-2/#date, http://www.w3.org/TR/xmlschema-2/#dateTime). But the string formats used by XML Schema don't seem to be compatible with what you are looking for.

A third alternative is to use Java extension functions to manipulate dates; a simple example is available in "IntDate.xsl" (javaExtension) in the Stylus Studio examples.

Hope this helps,
Minollo

Topic Page 1 2 3 4 5 6 7 8 9

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 to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

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.