Difference between two months

[Anonymous]

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?

[#2 · Accepted solution]

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]

Hi,

Try this

http://community.qlik.com/docs/DOC-3836

Regards,

Jagan.