Computing date/day patterns

baseliner · August 25th, 2011, 06:15 PM

Hi,

Given a set of dates in XML format (see below for sample XML), I need to compute the following information:

- what day of the month it is, e.g. 1st, 2nd, .. , nth, last (this is an easy one)
- the nth weekday of the month it corresponds to, e.g. 1st Monday, 2nd Wednesday, last Friday
- the nth month that it belongs to amongst the months involved in the set of dates, e.g. given dates from August 25 to October 15, September 5th would have n = 2

Here's a sample XML node:

Code:

<period date="12/6/2011" day="Tue" month="Dec" year="2011">

Are there any functions in XSLT that would provide this type of info or make this task easier to implement?

Thanks!

mhkay · August 25th, 2011, 07:42 PM

First convert the date to ISO format YYYY-MM-DD, using regex functions or simply substring-before/after. Then you can convert to xs:date(), and then you have a wide range of functions and operators available, for example subtracting two dates to get a dateTimeDuration. Also look at format-date() which has some extra capabilities like getting the ISO week number (week within year) or the week-within-month.

baseliner · September 14th, 2011, 07:33 PM

Thanks Michael for pointing me to that function.. I was able to do most of what I needed. Appreciate the help.