difference b/w dates

[prabhas277]

Hi

I have 2 dates date 1=18/3/2015   and date 2 =18/3/2013

Now I want how many months difference between these 2 dates by using qlikview function?

[maxgro · Accepted solution]

use year and month functions

Month(Date2)-Month(Date1)+(Year(Date2)-Year(Date1))*12

[sibideepak]

Hi prabhas277,

Check this out & try

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