Code in XSLT to compare dates?

[Melay]

What should be the code written in XSLT that will allow me to compare dates from a SQL Server (let's say, SQLExpress)?

[jake cigar™ is retired]

if the dates are stored as integer it's simple, if they are strings yyyymmdd, also easy.

if they are messy US style you have to do a lot of manipulation.

http://www.dpawson.co.uk/xsl/sect2/dates.html

make sure the sql select reformats the the date to a natural format for simple comparisons
XSLT 2.0 can compare date values directly (once they're in ISO format).

XSLT 1.0 can only compare numbers. You can convert an ISO date to a number by removing the punctuation: translate($in, '-', ''). To convert a US date to an ISO date, use a combination of substring() and concat().