Format Date/Time
Date Formatter
Description
Formats ISO Dates into various different output styles using a simple format syntax.
XSLT
View Raw
<?xml version="1.0" encoding="utf-8"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <!-- Description: This is a date formatting utility. The named template "format-date" takes 2 parameters: 1. date - [required] takes an ISO date (2005-12-01) 2. format - [optional] takes a format string. Format options: Y - year in 4 digits e.g. 1981, 1992, 2008 y - year in 2 digits e.g. 81, 92, 08 M - month as a full word e.g. January, March, September m - month in 3 letters e.g. Jan, Mar, Sep N - month in digits without leading zero n - month in digits with leading zero D - day with suffix and no leading zero e.g. 1st, 23rd d - day in digits with leading zero e.g. 01, 09, 12, 25 x - day in digits with no leading zero e.g. 1, 9, 12, 25 T - time in 24-hours e.g. 18:30 t - time in 12-hours e.g. 6:30pm W - weekday as a full word e.g. Monday, Tuesday w - weekday in 3 letters e.g. Mon, Tue, Wed Examples: M => January d M => 21 September m D, y => Sep 21st, 81 n-d-y => 09-21-81 d/n/y => 21/09/81 d/n/y t => 21/09/81 6:30pm --> <xsl:template name="format-date"> <xsl:param name="date"/> <xsl:param name="format" select="'D M, Y'"/> <xsl:choose> <xsl:when test="string-length($format) <= 10"> <xsl:call-template name="date-controller"> <xsl:with-param name="date" select="$date"/> <xsl:with-param name="format" select="$format"/> </xsl:call-template> </xsl:when> <xsl:otherwise> <xsl:text>Error: format parameter is not correctly set. You have: </xsl:text> <xsl:value-of select="string-length($format)"/> <xsl:text>.</xsl:text> </xsl:otherwise> </xsl:choose> </xsl:template> <xsl:template name="date-controller"> <xsl:param name="date"/> <xsl:param name="format"/> <xsl:param name="letter" select="substring($format,1,1)"/> <xsl:param name="tletter" select="translate($letter,'DMNYTW','dmnytw')"/> <xsl:choose> <xsl:when test="$tletter = 'y'"> <xsl:call-template name="format-year"> <xsl:with-param name="date" select="$date"/> <xsl:with-param name="format" select="$letter"/> </xsl:call-template> </xsl:when> <xsl:when test="$tletter = 'm'"> <xsl:call-template name="format-month"> <xsl:with-param name="date" select="$date"/> <xsl:with-param name="format" select="$letter"/> </xsl:call-template> </xsl:when> <xsl:when test="$tletter = 'n'"> <xsl:call-template name="format-month"> <xsl:with-param name="date" select="$date"/> <xsl:with-param name="format" select="$letter"/> </xsl:call-template> </xsl:when> <xsl:when test="$tletter = 'd'"> <xsl:call-template name="format-day"> <xsl:with-param name="date" select="$date"/> <xsl:with-param name="format" select="$letter"/> </xsl:call-template> </xsl:when> <xsl:when test="$tletter = 'x'"> <xsl:call-template name="format-day"> <xsl:with-param name="date" select="$date"/> <xsl:with-param name="format" select="$letter"/> </xsl:call-template> </xsl:when> <xsl:when test="$tletter = 't'"> <xsl:call-template name="format-time"> <xsl:with-param name="time" select="$date/@time"/> <xsl:with-param name="format" select="$letter"/> </xsl:call-template> </xsl:when> <xsl:when test="$tletter = 'w'"> <xsl:call-template name="format-weekday"> <xsl:with-param name="weekday" select="$date/@weekday"/> <xsl:with-param name="format" select="$letter"/> </xsl:call-template> </xsl:when> <xsl:otherwise> <xsl:value-of select="$letter"/> </xsl:otherwise> </xsl:choose> <xsl:if test="$letter = not('')"> <xsl:call-template name="date-controller"> <xsl:with-param name="date" select="$date"/> <xsl:with-param name="format" select="substring($format,2)"/> </xsl:call-template> </xsl:if> </xsl:template> <xsl:template name="format-year"> <xsl:param name="date"/> <xsl:param name="year" select="substring($date,1,4)"/> <xsl:param name="format" select="'y'"/> <xsl:choose> <xsl:when test="$format = 'y'"> <xsl:value-of select="substring($year,3)"/> </xsl:when> <xsl:when test="$format = 'Y'"> <xsl:value-of select="$year"/> </xsl:when> </xsl:choose> </xsl:template> <xsl:template name="format-month"> <xsl:param name="date"/> <xsl:param name="month" select="format-number(substring($date,6,2), '##')"/> <xsl:param name="format" select="'m'"/> <xsl:param name="month-word"> <xsl:choose> <xsl:when test="$month = 01">January</xsl:when> <xsl:when test="$month = 02">February</xsl:when> <xsl:when test="$month = 03">March</xsl:when> <xsl:when test="$month = 04">April</xsl:when> <xsl:when test="$month = 05">May</xsl:when> <xsl:when test="$month = 06">June</xsl:when> <xsl:when test="$month = 07">July</xsl:when> <xsl:when test="$month = 08">August</xsl:when> <xsl:when test="$month = 09">September</xsl:when> <xsl:when test="$month = 10">October</xsl:when> <xsl:when test="$month = 11">November</xsl:when> <xsl:when test="$month = 12">December</xsl:when> </xsl:choose> </xsl:param> <xsl:choose> <xsl:when test="$format = 'm'"> <xsl:value-of select="substring($month-word, 1,3)"/> </xsl:when> <xsl:when test="$format = 'M'"> <xsl:value-of select="$month-word"/> </xsl:when> <xsl:when test="$format = 'n'"> <xsl:value-of select="format-number($month, '00')"/> </xsl:when> <xsl:when test="$format = 'N'"> <xsl:value-of select="format-number($month, '0')"/> </xsl:when> </xsl:choose> </xsl:template> <xsl:template name="format-day"> <xsl:param name="date"/> <xsl:param name="day" select="format-number(substring($date,9,2),'00')"/> <xsl:param name="format" select="'d'"/> <xsl:param name="suffix"> <xsl:choose> <xsl:when test="(substring($day,2) = 1) and not(substring($day,1,1) = 1)">st</xsl:when> <xsl:when test="(substring($day,2) = 2) and not(substring($day,1,1) = 1)">nd</xsl:when> <xsl:when test="(substring($day,2) = 3) and not(substring($day,1,1) = 1)">rd</xsl:when> <xsl:otherwise>th</xsl:otherwise> </xsl:choose> </xsl:param> <xsl:choose> <xsl:when test="$format = 'd'"> <xsl:value-of select="$day"/> </xsl:when> <xsl:when test="$format = 'x'"> <xsl:value-of select="format-number($day,'0')"/> </xsl:when> <xsl:when test="$format = 'D'"> <xsl:value-of select="format-number($day,'0')"/> <xsl:value-of select="$suffix"/> </xsl:when> </xsl:choose> </xsl:template> <xsl:template name="format-time"> <xsl:param name="time"/> <xsl:param name="hour" select="substring-before($time, ':')"/> <xsl:param name="minute" select="substring-after($time, ':')"/> <xsl:param name="format" select="'T'"/> <xsl:choose> <xsl:when test="$format = 'T'"> <xsl:value-of select="$time"/> </xsl:when> <xsl:when test="$format = 't'"> <xsl:choose> <xsl:when test="$hour mod 12 = 0">12</xsl:when> <xsl:otherwise><xsl:value-of select="($hour mod 12)"/></xsl:otherwise> </xsl:choose> <xsl:value-of select="concat(':',$minute)"/> <xsl:choose> <xsl:when test="$hour < 12">am</xsl:when> <xsl:otherwise>pm</xsl:otherwise> </xsl:choose> </xsl:when> </xsl:choose> </xsl:template> <xsl:template name="format-weekday"> <xsl:param name="weekday"/> <xsl:param name="format" select="'w'"/> <xsl:param name="result"> <xsl:choose> <xsl:when test="$weekday = 1">Monday</xsl:when> <xsl:when test="$weekday = 2">Tuesday</xsl:when> <xsl:when test="$weekday = 3">Wednesday</xsl:when> <xsl:when test="$weekday = 4">Thursday</xsl:when> <xsl:when test="$weekday = 5">Friday</xsl:when> <xsl:when test="$weekday = 6">Saturday</xsl:when> <xsl:when test="$weekday = 7">Sunday</xsl:when> </xsl:choose> </xsl:param> <xsl:choose> <xsl:when test="$format = 'W'"> <xsl:value-of select="$result"/> </xsl:when> <xsl:when test="$format = 'w'"> <xsl:value-of select="substring($result,1,3)"/> </xsl:when> </xsl:choose> </xsl:template> </xsl:stylesheet>