1 Reply Latest reply: Jul 25, 2016 4:47 PM by Sunny Talwar RSS

    Help with date SET analysis - previous month



      I need some help, and this has probably been asked a million times before, I just cant get it to work. I need to write a SET analysis for the previous months value count, however I want to use a date range and avoid using variables:


      Count({$<Lead_Created_date={">=$(=addmonths(monthstart(max(Lead_Created_date)),-1))<=$(=addmonths(monthend(max(Lead_Created_date)),-1))"},OutcomeName={'Not interested'}>}Reference)


      This doesnt return a value, however im sure the code is correct, the issue probably is that Lead_Created_date is a datetime field. Not sure if there is a way to solve this, can anyone help plz?


      Thanks in advance.