AnsweredAssumed Answered

Case Statement using AND OR

Question asked by themactech. on Oct 7, 2014
Latest reply on Oct 7, 2014 by themactech.

Title

Case Statement using AND OR

Post

Hi everyone

 

I have this Case Statement in a calculated field call OFF-SITE

Case 
( Inspection Type = "Shipment - Offsite" or Inspection Type = "Receipt/Shipment" and Planned Ship Date < Get ( CurrentDate ); "OFF-SITE"; "ON-SITE")

Inspection Type has multiple selections and Planned Ship Date could be any date the user sets.

The idea is if the user selects either of those two options and the Planned Ship Date is less than today's date then the calculated field shows the text OFF-SITE. Otherwise it should show ON-SITE

I thought it was working but the user just showed me that if they choose "Shipment - Offiste"  and select a ship date that is greater than today it still shows OFF-SITE

What did I do wrong here?

 

Screen_Shot_2014-10-07_at_2.39.05_PM.png

Outcomes