0 Replies Latest reply: Oct 31, 2017 12:08 PM 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)