1 Reply Latest reply: May 5, 2014 3:18 AM by Tresesco B RSS

    Set Expression of 'InMonthToDate'

    Atsushi Saijo

      Dear Gurus,

       

      I have used InMonToDate in current project, not least it allows Financial Year and standard Calendar Year easily switched by having start month. But if I needed to achieve this in set expression, how could I write it?

       

      • [Expression]

       

       

      • [in Set Analyses]

      Date =

           {"

                >=$(=MonthStart(Today(0),$(=-X)))

                >=$(=MonthEnd(Today(0),$(=-X)))

           "}

       

      Above is one thought to achieve InMonthToDate, but is there something like:

       

      $(=InMonthToDate(....)) ?

       

      I'd apprecaite for any feedback in advance.

       

      [Additional Question 2.] is it the case, that I cannot write set analyses in multiple lines, but always need making it being single line?