topic Re: Difference between two months in QlikView

Difference between two months

Anonymous — Wed, 01 May 2013 15:24:11 GMT

I've got a table with the field OpenDate and i'd like to know how many months have passed between that date and today, can anyone suggest a formula?

Wed, 01 May 2013 15:51:10 GMT

Hi,

i think you meant something like that:

...

num(month(now())) - num(month(OpenDate)) + (year(now()) - year(OpenDate))*12 as monthDiff

or absolut

fabs(num(month(now())) - num(month(OpenDate)) + (year(now()) - year(OpenDate))*12) as monthDiff

...

Best

Sacho

jagan — Wed, 01 May 2013 15:54:02 GMT

Hi,

Try this

Regards,

Jagan.