Can someone help me with this formula? I am trying to create a nested IIF (two statements) with and "AND". Is that doable, and if so, what am I missing? Thanks.
Expr1: IIf(Int((Now()-[Last Received Date])/365)>=2 And IIf(IsNull([Sales / Transfer Qty]),"No","Yes"))