topic Re: How to calculate difference between two dates in months - rounding to 1 decimal place in QlikView

How to calculate difference between two dates in months - rounding to 1 decimal place

triciagdaly — Fri, 16 Oct 2015 20:31:14 GMT

I am trying to calculate the difference in months between two dates but needing to round to one decimal place. I found the below on the forum, but do not understand the format. It is returning the number rounded.

Needing the difference between today and EFFECTIVE_DATE rounded to 1 decimal place.

year(today(2))*12)+month(today(2))) - (((year(EFFECTIVE_DATE)*12)+month(EFFECTIVE_DATE)))

Thank you!

Re: How to calculate difference between two dates in months - rounding to 1 decimal place

sunny_talwar — Fri, 16 Oct 2015 20:33:42 GMT

Check this link out by jagan‌: Calculating Months difference between two dates

Re: How to calculate difference between two dates in months - rounding to 1 decimal place

triciagdaly — Fri, 16 Oct 2015 20:49:57 GMT

I was hoping for an explanation of the formula I sent. Thanks anyway.

Re: How to calculate difference between two dates in months - rounding to 1 decimal place

swuehl — Fri, 16 Oct 2015 23:46:47 GMT

Since your formula just calculates difference between two integers (using sequential month numbers started in Jan 0000 for two dates), you can't calculate something with significant decimal places from that.

Here is a thread that covers some alternatives and also tries to explain the difficulty in defining a 'month' distance between dates:

How Do I Get the Number of Months Between Two Dates?

edit:

And if you want a more accurate calculation of date difference in Year,Month, Days, maybe use something like

day month year shows two dates qlikview