I have field u_date and need to check if the current date is greater to u_date by 15 min.

sachujayakumar · ‎11-19-2019

asifnoor · ‎11-20-2019

Okay. Then simply make the BR to display query instead of after insert.

Then your Br executes whenever you open the incident. And if the incident u_date+15 minutes is more than current date, then you can show the message saying

gs.addInfoMessage("Current date is greater than u_date");

Mark the comment as a correct answer and also helpful if this answers your question.

View solution in original post

sachujayakumar · ‎11-20-2019

Hello Asif,

Regards,

sachu Pillai

asifnoor · ‎11-20-2019

The 3rd log is missing. can you check and share that as well. If that is not coming, then it means there is an error you might see in your logs. Kindly check that.

gs.log("current date/time is "+gd1);

sachujayakumar · ‎11-20-2019

here you go

asifnoor · ‎11-20-2019

Hi,

So as you can see the logs, your u_date (after adding 15 mins) is 10:02:36

and your current date/time is 09:46:11

Hence it is not entering your if condition.

When the current time crosses the u_date time, then it will enter the if condition.

Mark the comment as a correct answer and also helpful if this answers your question.

sachujayakumar · ‎11-20-2019

Hello ,

So How Can I pop an alert once the 15 min is crossed.

if current time is (u_date+15 min) then the user should come to know, an alert or an error message should pop up.