sc:formatdate(sc:fld('MyDateField', .),
'd MMM yyyy @ h:mm')
However, extracting just the month as a number without padding is less obvious. Using the format string 'MMM' gives three-letter month names, 'MM' gives months padded with zeros (eg. 02 for Feb), while 'M' curiously gives full month name and date padded with zeros.
A workaround is to use substring-after in conjunction with the format '/M'. Example:
substring-after(sc:formatdate(
sc:fld('MyDateField', .), '/M'), '/')
1 comment:
Hey Niel,
You can do the same, from within XSLT using the date custom sc xsl control, e.g.:
< sc:date format="d MMM yyy @ h:mm" />
The formats are traditional .NET formats:
http://msdn2.microsoft.com/en-us/library/73ctwf33(vs.71).aspx
Post a Comment