3 Replies Latest reply on Mar 11, 2018 6:30 AM by Ritesh Bisht

    unable to compare two date times.

    archana.garikapati

      I am unable to compare two datetime values. it says invalid timestamp. please assist.

       

      if [PROC_STRT_TS] >= [SLA StTS  Date] then -1

      else 1

      end

       

       

       

      format of proc_strt_ts is 3/6/2018 15:15:19.000000 which is from Teradata database.

       

      format of SLA StTS  Date =  datetime([SLA StTS ])

       

      SLA StTS = str(month(TODAY()))+"/"+str(day(dateadd('day',-1,today())))+"/"+str(year(today()))+" 10:00:00 PM"