date range + # of days

[#1]

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

[settu_periasamy]

Hi,

This One?

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

[maxgro · Accepted solution]

=count({<COUNT_DATE={">=$(vStartDate)<=$(=Date(30+(vEndDate)))"},REAL_PLAY_COUNT={1}>}  distinct PARTY_ID) 

[#4]

sorry for the delay in responding guys, thanks for the quick answers. I lost access to the data for a few days. I'm checking those now.

[#5]

Thanks guys! I used Maxgro's solution but they both worked