Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.
Jonny,
'=' sign to ignore field selection is optional. So, original syntaxis is correct.
Thanks!