1 Reply Latest reply: Nov 27, 2017 4:40 AM by chitraxi raj RSS

    Find Customer name who ordered on Latest Month -end date available.

    chitraxi raj

      Hi All,


      I want to find data for all the customers who made an order on latest month -end date. For Example, today is 15 -oct so Fetch data for 30-sep.


      Step I tried,


      $(vLatestMonthEnd) :     date(max({$<IsMonthEnd={1}>}BusinessDate),'MM/DD/YYYY')


      But when I am trying to fetch data for above date it is giving me invalid dimension.


      Dimension: if(date='$(vLatestMonthEnd)',CustomerName)