6 Replies Latest reply: Apr 9, 2018 10:55 AM by Youssef Belloum RSS

    MMMYYYY comparison

    Arjun Madhusudan

      I have two filters  Year  and MonthYear (MMMYYYY format).

      User can select only year or year and MonthYear both or just MonthYear

       

      CreatedMonthYears and CloseMonthYear are also in MMMYYYY format and  MonthYears is also in MMMYYYY format.

       

      Year comparison shown below works well for me but MonthYear comparison which is in MMMYYYY format does not work. .

       

      However I don't think MMMYYYY comparison works the year to year comparison id done in case of CloseYear.

       

      Need help here.

       

      Count({

      $<

      CreatedYear = {"<=$(=max(Years))"},

      ClosedYear = {">$(=max(Years))"},

      CreatedMonthYear = {"<$(=max(MonthYears))"},

      CloseMonthYear = {">$(=max(MonthYears))"}

       

      + <

      CreatedYear = {"<=$(=max(Years))"},

      ClosedYear = {'0'},

      CreatedMonthYear = {"<$(=max(MonthYears))"},

      CloseMonthYear = {'0'}

       

      >

      } Distinct Outletid)