How can I calculate the DifferenceIn Months?

[#1]

Hi all,

I have a startdate and enddate

StartDate : 26/06/2013

EndDate : 02/08/2013

When I use the calculator Windows, the result is 1 month and 1 week , in qv it is 2month.

How can I have the result like the Windows calculator?

Thank for your help.

[nagaiank]

http://community.qlik.com/message/667406#667406

[rwunderlich]

How do you want to use this value in QV? QV does not have an actual week interval. So for you above example, should it be something like "1.25 months" or do you want it to display "1 month and 1 week"?

-Rob

[#4]

Maybe like attached?\

[#5]

Hi Rob,

I would like just month.

Ajay your approach is good but if the month the end month possible is 28,30,31 not only 30.

[#6]

Rob, yes, I would like 1.25

[rwunderlich]

How precise do you need to be? Can you just divide the number of days by 30?

(EndDate - StartDate)  / 30

[#8]

The calculator give me 1.2164383561655998.

(EndStart - StartDate) / 30 give me 1,2333333333333

Is it possible to have the value close to the calculator result or qlikview does an approximation ?

Thanks

[MarcoWedel]

What did you type into your calculator to get this value?

[#10]

I use the calculator Windows (Ctrl+E)

From : 26/06/2013

To : 02/08/2013