Get Years Between Two Dates

Belch · July 29th, 2013, 11:10 AM

Hi,
I need to get the number of years between two dates, which I have managed in a roundabout way, but surely there is a more streamlined solution?

My code is:

Code:

 years-from-duration(((current-date() - xsd:date(otherDate)) div xsd:dayTimeDuration('P1D')) div 365.242199 * xsd:yearMonthDuration('P1Y'))"

This works but relies on a division of 365.242199 days.

I appreciate XPath is not a programming language, so maybe this is the only way, but is there anything in place that would return the number of years more accurately?

Thanks in advance.

mhkay · July 29th, 2013, 11:26 AM

It would be interesting to know what you think the rules should be. For example how many years are there between 28 Feb 2013 and 29 Feb 2012? The reason there's no function/operator for this in XPath 2.0 is because the WG couldn't agree on detailed semantics.

Belch · July 30th, 2013, 04:40 AM

Hi Michael,

Yes I thought that might be the case, I just wanted to check there wasn't a date function I hadn't spotted.

The sooner we can start using Star Trek "stardates", the better!

Thanks for your help.