5 Replies Latest reply on Dec 28, 2018 10:54 AM by maneesh.gaddam

    How do I compare DATETIME?

    Ghan Shyam

      I have two date columns that I am trying to compare the date and time. The logic I want to apply is below


      if (Date_1, 'MM/dd/YYYY  HH24:MI') <= (DATE_2, 'MM/dd/YYYY  HH24:MI')

      THEN 'PASS' ELSE 'FAIL'  end


      How do I perform this logic in a calculated field?  Both date columns are in the format  'MM/dd/YYYY HH24:MI AM/PM) if that helps.