2 Replies Latest reply on Oct 7, 2014 1:05 PM by themactech.

    Case Statement using AND OR

    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