AND Function does not work

[ashissanpui]

Hi team,

I am trying to use AND formula which is similar to AND function present in MS Excel. Could you guide me how to use the same? I am in dire need.

Let me know your best approach to this.

Thank You,

Ashis Sanpui

[CharlieS · Accepted solution]

In Alteryx expressions: the "AND" ("&&" also works) is an operator and not a formula. Think of it as a "+" for conditions.

In Excel: AND([A]=1,[B]=1)

In Alteryx: [A]=1 AND [B]=1

or ([A]=1 AND [B]=1) if the parenthesis help.

[ashissanpui · Accepted solution]

Thank you @CharlieS for the solution. It did work for me.

[Arunkumar25]

Hi, I try to use the "AND" function in the filter. my requirement is to filter the date approval from yesterday to today.  this is a custom formal which I tried "[Date Approved] = DateTimeToday() AND [Date Approved]= ToDate(DateTimeAdd(DateTimeToday(), -1, "days"))".

the above formula doesn't work if tried separately today or yesterday date is working. 

Could you please advise me