9 Replies Latest reply: Nov 2, 2016 4:59 AM by jagan mohan rao appala RSS

    String compare

    Aniruddhya Dutta

      Hi All,

       

      I want to compare two dates which are coming as strings in db

       

      I created a flag field for comparing the times which is

       

      if (timestamp(SCHEDULE_TIME,'h:mm TT') > (timestamp(Timestamp(now(0)-30/(24*60)),'h:mm TT')),1) 

      but every time I am getting the flag value as 1.

       

      compare.PNG

       

      but ideally I should get flag as 0 for 9 AM entry.

      Kindly help.