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

    Help with date SET analysis - previous month

    Ridwaan Shaik

      Hi,

       

      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.

       

      Regards,

      Ridwaan