5 Replies Latest reply on Aug 30, 2018 11:13 AM by Michael Gillespie

    Can't Compare Date and String Values

    shareq.mohammed

      I am trying to achieve the below:

      i.e. if Date is equal to '12/31/9999' then I want to display 'Not Submitted' else date

      I keep getting the error "Can't Compare Date and String Values"

       

      IF [DATE] = "12/31/9999" then "Not Submitted" Else [DATE] End