substring workaround

Steve_Walker · September 16, 2003, 1:59pm

Hi,

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.

Thanks,
Steve

Bill_Keese1 · September 17, 2003, 1:13pm

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

<dob><year>1967</year><month>10</month><day>20</day></dob>

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

Bill