General

Re: Difference in Months between 2 dates

Mgauf — Thu, 11 Nov 2010 12:45:23 GMT

Thank you. Thank you. Thank you.

Re: Difference in Months between 2 dates

Jimmy — Tue, 09 Nov 2010 15:55:10 GMT

How about

(12 * (substring(date2, 1, 4) - substring(date1, 1, 4))) + (substring(date2, 6, 2) - substring(date1, 6, 2))

Re: Difference in Months between 2 dates

Mgauf — Tue, 09 Nov 2010 15:47:26 GMT

I failed to mention that the date picker fields can be more than 1 calendar year. For example, i would need a formula that would resolve the difference in months between 11/1/2010 and 11/1/2008. Thanks again for your assistance.

Re: Difference in Months between 2 dates

ErnestoM — Tue, 09 Nov 2010 13:25:23 GMT

Perhaps I'm oversimplifying the problem, but I'm attaching a form that does some simple calculations.

If you'd like something more robust (taking days/hours into account), you could use the DiffDate command in qRules.

Difference in Months between 2 dates

Mgauf — Tue, 09 Nov 2010 13:14:07 GMT

I am looking for a solution for to show the difference in months between two dates. I tried the Excel solution (=(YEAR(LDate)-YEAR(EDate))*12+MONTH(LDate)-MONTH(EDate)), but get a formula error: "'YEAR' is not a valid XSLT or XPath function.".

Any assistance would be aqppreciated.

Thanks