1 Reply Latest reply: Nov 14, 2016 4:17 AM by Shraddha Gajare RSS

    Difference of YearMonth format

    Rima Hajou

      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,