topic Months Between Two Dates in QlikView

Months Between Two Dates

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi, I'm a bit new at QV and would like to calculate months between two dates. Struggling a bit to write this...

=if(EXIT_DATE Isnull then addmonths_between(ENTRY_DATE and TODAY())

else

addmonths_between (ENTRY_DATE and EXIT_DATE)

mdmukramali — Wed, 15 Nov 2017 10:48:12 GMT

Hi,

FYI.

devarasu07 — Wed, 15 Nov 2017 10:53:54 GMT

Hi,

try like this,

set variable like below,

SET MonthDiff = Num(((year($2) * 12) + month($2)) - (((year($1) * 12) + month($1))) + 1);

load *, $(MonthDiff(FromDate, ToDate)) AS MonthsDifference;

load * Inline [

FromDate,ToDate

2017-01-25,2017-09-19

2016-02-25,2017-03-19

];