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?