cmj

Simple If Calculation

Discussion created by cmj on Jan 30, 2019
Latest reply on Jan 30, 2019 by cmj

I've had a brain drain and can't figure this calculation out (boolean) in a script.

This works:

If ($MaxDate  ≥ Expired::BestBefore)

 

However, I want to see if any fruits, Not Including Apples, have a $MaxDate that's ≥ Expired::BestBefore .

If (Fruits::FruitName <> "APPLE" and $MaxDate  ≥ Expired::BestBefore)

This provides the same results as the first calculation, ignoring Apples.

 

Thanks!

Outcomes