5 Replies Latest reply: Oct 13, 2017 3:32 AM by beck bakytbek RSS

    difference in months

    beck bakytbek

      Hi Folks,

       

      i have a following case, i have 2 Fields: From Date and To Date,

       

      case 1:

      From_Date          To_Date

      21.03.2015          25.03.2015

       

      if i use this procedure :

       

      Date(Date#(From_Date, 'DD.MM.YYYY'))as From_Date,

      Date(Date#(To_Date, 'DD.MM.YYYY'))as To_Date,

      Num(To_Date) - Num (From_Date), so i can calcualte the Difference in Days, and it does work great

       

      Problem Case:

      From_Date          To_Date

      06.10.2017          06.05.2019 > How can i calculate in this case  the Difference in months

       

      Thanks a lot for any feedback and help

       

      Beck