Altova Mailing List Archives>Archive Index >microsoft.public.xsl Archive Home >Recent entries >Thread Prev - Comparing dates in xsl [Thread Next] Re: Comparing dates in xslTo: NULL Date: 9/12/2006 12:32:00 AM
2netrall wrote:
> I have a date retrived from the database and if the date is in the future I
> will display a buttom and if it is in the past I will display a text message.
> The date of today I have put in a parameter called dtDate and it has the
> format DD.MM.YYYY.
Never, never store dates in non-comparable formats :-)
Use ISO 8601, eg yyyy-mm-ddThh:mm:ss
> the dueDate that I wants to compare I put in a variable
> because dueDate has not the same format and has to be converted to the same
> format, When I do he compare it always returns false, i.e. never creates the
> buttom
>
> <xsl:variable name="tmpDate"><xsl:apply-templates
> select="dueDate"/></xsl:variable>
> <xsl:if test="$tmpDate >key('param','dtDate')">
> <cell style="button">
>
> Has anyone compared dates in xsl and have any tip?
XSLT 1 doesn't do alpha string compares, only numeric, so
you'll need to split up your date and recombine it into a
usable form (yyyymmdd) without the periods, and do the
compare numerically.
///Peter
| ||||||
| Company | Legal | Press | Partners | Careers | Sitemap | Contact Us | Altova Blog | Mobile | Full Site | |||
|
