None

[bgerchikov]

Hi,

First, make sure date_dt, $(vMinDate) and $(vMaxDate) have exactly the same format. Preferably numeric. 

Second, make sure variables $(vMinDate) and $(vMaxDate) have values.

Third, try to use '~' instead of double quotes in set expression.

Hope, it would help.

[JonnyPoole · Accepted solution]

Make sure your expression works without the PROMO_CODE modifer.  

IE:  Count({<date_dt={">=$(vMinDate)<=$(vMaxDate)"}>} Distinct playnow_id)

..if that work as you expect try using an empty = after the field name:

Count({<PROMO_CODE=,date_dt={">=$(vMinDate)<=$(vMaxDate)"}>} Distinct playnow_id)

..PROMO_CODE= is syntax that should ignore any PROMO_CODE selection just like as if it wasn't selected. 

[bgerchikov]

Jonny,

'=' sign to ignore field selection is optional. So, original syntaxis is correct.

Thanks!