topic Re: diff in month betweeen two dates in QlikView

diff in month betweeen two dates

souadouert — Fri, 20 Apr 2018 10:41:29 GMT

I have two date 20180130 - 20180228 and i need to calculate the number of months between two date in straight table (CHART)
so in my example i have to find 1 MONTH

Re: diff in month betweeen two dates

tresB — Fri, 20 Apr 2018 10:48:53 GMT

First convert the dates using date# with proper format like: Date#( Date1, 'YYYYMMDD') and then follow one method like shown here:

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

Calculating Months difference between two dates

Re: diff in month betweeen two dates

sasiparupudi1 — Fri, 20 Apr 2018 10:50:54 GMT

Interval(Date#('20180228','YYYYMMDD')-Date#('20180130','YYYYMMDD'),'d')

Re: diff in month betweeen two dates

sasiparupudi1 — Fri, 20 Apr 2018 11:21:36 GMT

(Year(Date#(20180228,'YYYYMMDD'))*12+Month(Date#(20180228,'YYYYMMDD')))

(Year(Date#(20180130,'YYYYMMDD'))*12+Month(Date#(20180130,'YYYYMMDD')))