Difference of YearMonth format

Mon, 14 Nov 2016 09:11:47 GMT

Hello,

I have this table:

ID | StartDate | EndDate | Result | Expected Result

1 | 201306 | 201710 | 174.5 | 172

2 | 201505 | 202006 | 61.9 | 61

3 | 201608 | 202108 | 60.8 | 60

4 | 201308 | 201708 | 48.7 | 48

5 | 201309 | 201808 | 59.83 | 59

6 | 201410 | 202409 | 120.7 | 119

7 | 201608 | 201807 | 23.3 | 23

My goal is to find the duration between StartDate and EndDate in months. I figured out a way to do that by calculating the number of DAYS between these 2 days using this formula: (Result column)

(num(MonthYear_Mat)- num(MonthYear_Dis) )/30

but this result has a major error that it count every month as 30 days, and the result isn't 100% accurate.

How to obtain the Expected result?

Thanks,

Re: Difference of YearMonth format

shraddha_g — Mon, 14 Nov 2016 09:17:13 GMT

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

topic Difference of YearMonth format in QlikView

Difference of YearMonth format

Re: Difference of YearMonth format