topic How do I get the difference in months between 2 dates that are in different format? in QlikView

How do I get the difference in months between 2 dates that are in different format?

Panri93 — Tue, 22 Feb 2022 09:29:35 GMT

Hi everyone!

I'm new at Qlik. I was wondering how to obtain the difference in months between two dates that are in different formats. For example:

Date 1: 13/06/2020 (DD/MM/YYYY)

Date 2: 2020/05 (YYYY/MM)

For the example above, I should obtain 1 month.

Note: Both fields are in date format so no conversion is needed.

Any idea?

Re: How do I get the difference in months between 2 dates that are in different format?

anat — Tue, 22 Feb 2022 10:17:24 GMT

month(date(date#('13/06/2020','DD/MM/YYYY'),'MM/YYYY'))-month(date(date#('2020/05','YYYY/MM'),'MM/YYYY'))

else u can try below link method

Solved: Count number of months between two dates - Qlik Community - 1540620

Re: How do I get the difference in months between 2 dates that are in different format?

MarcoWedel — Tue, 22 Feb 2022 17:44:51 GMT

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

Re: How do I get the difference in months between 2 dates that are in different format?

Harvey — Thu, 24 Feb 2022 03:51:45 GMT

@ToysRUSCreditCard wrote:

Hi everyone!

I'm new at Qlik. I was wondering how to obtain the difference in months between two dates that are in different formats. For example:

Date 1: 13/06/2020 (DD/MM/YYYY)

Date 2: 2020/05 (YYYY/MM)

For the example above, I should obtain 1 month.

Note: Both fields are in date format so no conversion is needed.

Any idea?

Try: Month(Date#(End_date,'DD-MM-YYYY'))-Month(Date#(Start_date,'DD-MM-YYYY'))

((year(Date#('31-02-2019','DD-MM-YYYY'))*12)+month(Date#('31-02-2019','DD-MM-YYYY'))) - (((year(Date#('01-01-2018','DD-MM-YYYY'))*12)+month(Date#('01-01-2018','DD-MM-YYYY'))))