11 Replies Latest reply: Nov 28, 2017 6:44 AM by Jose Persichini RSS

    Set current MonthYear in a variable

    Jose Persichini

      Hello, I am using MasterCalendar and I want to filter data which is from current MonthYear.

       

      I create this variable:

       

      vCurrentMonthYear = Date(monthstart(Today()),'MMM-YYYY')

       

      but when I use it in a set expression, for example like this:

       

      SUM({MonthYear={$(vCurrentMonthYear)}} sale_total)

       

      don't select anything. Why?