4 Replies Latest reply: Dec 1, 2015 2:33 PM by Grant Rosenthal RSS

    date range + # of days

      Hi,

       

      I'm certain I've come across this before but am unable to find it again. I have a count using set analysis in a date range, but I'm wanting to increase the date variables by a defined number of days. For the sake of this example I'll say by 30 days. Here's the statement I currently have:

       

      =COUNT(
              {$
                   <
      COUNT_DATE={">=$(vStartDate)<=$(vEndDate)"},REAL_PLAY_COUNT={1}>
              }
      distinct PARTY_ID
      )


      Thanks in advance


      Grant