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

    Can't Compare Date and String Values


      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