2 Replies Latest reply: May 11, 2014 3:09 PM by John Cavoulas RSS

    Max sales date from March

    Ville Syrjänen

      Hi,

       

      I'm desperately trying to catch last sales date from two months back. Since it's May now, I shoud find last date from March. This is how I tried to do that:

       

      sum(Month(AddMonths(Date(Today()),-2)), 'M/D/YYYY'), {<[Snapshot Date] = date(max({1}[Snapshot Date])},Year = {$(=only(Year))} )