iif condition

[#1]

Hi team,

I have the below query written, however I keep getting an error.

iif(

(

([expr1438750422]  Between 1 And  9)  And [expr1438752997] <=12

)

And

(

[expr1438750422] >0 And ([expr1438752958] <= 6)

),"Active-F","NULL")

any ideas would be great..

thanks

Shiva

[#2 · Accepted solution]

Hi Shiva,

  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.

Regards,

  Linda

[#3]

Thanks Linda,

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) )

Regards

Shiva