There was a function to do this in earlier XSLT 2.0 drafts -
subtract-dates-yielding-yearMonthDuration or some such - but it was removed
because of difficulties in defining exactly what it should do.
One possible algorithm, which you can easily implement as a function, is
(year-from-date($d1) - year-from-date($d2))*12
+ (month-from-date($d1) - month-from-date($d2))
- if (days-from-date($d1) ge days-from-date($d2)) then 0 else 1
That works reasonably for $d2 < $d1. To handle $d1 < $d2 one approach is to
use the same formula as above, another is to return -($d2 - $d1). For
2007-05-31 - 2007-06-01 one approach gives you -1, the other gives you 0.
Another algorithm is to ignore the day entirely, and just use the year and
month components. Or you can divide the day by the number of days in that
month...
Michael Kay
http://www.saxonica.com/
-----Original Message-----
From: Ryan Puddephatt [mailto:rpuddephatt(_at_)teleflex(_dot_)com]
Sent: 01 June 2007 19:52
To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
Subject: [xsl] Calculating months between two dates
Hi,
I want to know if it is possible to calculate the number
of months between two dates. For example
xs:duration(xs:date('2009-09-23') -
current-date())
From this I get a result in days, is there a way to convert
this or change its result?
Thanks
Ryan
--
Ryan Puddephatt
Software Engineer
Teleflex Group - IT UK
1 Michaelson Square
Livingston
West Lothian
Scotland
EH54 7DP
e> rpuddephatt(_at_)teleflex(_dot_)com
<mailto:rpuddephatt(_at_)teleflex(_dot_)com>
t> +44(0)1506 407 110
f> +44(0)1506 407 108
w> www.teleflex.com <http://www.teleflex.com>
"Measuring programming progress by lines of code is like
measuring aircraft building progress by weight." - /Bill
Gates/ "If you lie to the compiler, it will get its revenge."
- /Henry Spencer/ "It's hard enough to find an error in your
code when you're looking for it; it's even harder when you've
assumed your code is error-free." - /Steve McConnell/ "If
builders built buildings the way programmers wrote programs,
then the first woodpecker that came along would destroy
civilization." - /Gerald Weinberg/
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail:
<mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--