8 Replies Latest reply: May 5, 2018 2:29 AM by Anil Samineni RSS

    count number of months

    Wanyun Yang

      I have a date 11/2017 and a year filter. I'm trying to count the number of months. I

       

      f I select year 2016 in the filter, it returns 0. If select 2017, returns 2 (11/2017, 12/2017). If select 2018, it will count till today, so returns 7 (11/2017, 12/2017, 01/2018, 02/2018, 03/2018/, 04/2018, 05/2018).

       

      What should the function be for this?

       

      Thanks in advance!