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

    unable to compare two date times.


      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





      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"