RE: Calculating months between two dates
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@xxxxxxxxxxxx] > Sent: 01 June 2007 19:52 > To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx > Subject: 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@xxxxxxxxxxxx <mailto:rpuddephatt@xxxxxxxxxxxx> > 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/
PURCHASE STYLUS STUDIO ONLINE TODAY!
Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!
Download The World's Best XML IDE!
Accelerate XML development with our award-winning XML IDE - Download a free trial today!
Subscribe in XML format