substring workaround


I have a node for dob that is formatted as “September 15, 2003”. I need to extract the year for two different purposes. One, for filtering the result set by year (eg. dobYear < 1965). Two, for calculating the number of instances by age bracket (eg. 24-29).

In the absence of a substring function what are the alternatives? I was hoping I could have done a substring on dob from dob length-4 to dob length.


The only thing I can think of is, as a workaround, store the year in the XML directly; for example,


Of course, you can still keep your original dob element too.