I have the below query written, however I keep getting an error.
([expr1438750422] Between 1 And 9) And [expr1438752997] <=12
[expr1438750422] >0 And ([expr1438752958] <= 6)
any ideas would be great..
It would be helpful to see the error you are getting. I have a couple of suggestions:
Instead of using the default expr alias provided by Adobe Campaign, type in your own alias in the form of @myValue. You shouldn't need the brackets around this.
Use single quotes in your arg2 and arg2, e.g. 'Acitve-F'
Try starting with a simpler expression and building up the expression once you have that working.
I have one more question :
I need help with the below statement, I trying to figure out what is wrong with it :
countdistinct(Iif(DateOnly(@sapInvoiceDate) > DateOnly(MonthsAgo(12) && DateOnly(@sapInvoiceDate) < GetDate() ),@id,0) )