4 Replies Latest reply: Nov 27, 2017 2:46 AM by Amit Saini RSS

    Script Logic Help

    Amit Saini

      Hi Folks,

       

      I'm using below logic to when I'm having condition based on "Hour".

       

      IF(Hour(Date) < 8, Date-1,Date)  as Date.tmp

       

      Now what I want to do is to have condition based on "Minutes"

       

      I need logic something like below:

       

      IF(Minute(Date) < 08:45:00, Date-1,Date)  as Date.tmp

       

      Please help!

       

      Regards,

      AS