JQL for current time - 5 mins

[Vignesh Jayagopal]

Hi All,

I have date/time custom field in my issue type.

Users will select the future date/time when raising the ticket.

I want my automation rule(running every 5 mins) to change the status of the ticket once the date/time mentioned in the ticket is crossed. I tried writing JQL in different ways but not working.

Can you help on this please. Below is the one i tried.

project = XXX AND status = SCHEDULED AND "Session start[Time stamp]">=-6m order by created DESC

[Mark Segall · Accepted solution]

Hi @Vignesh Jayagopal 

I believe you want a subtle tweak to less than:

project = XXX AND status = SCHEDULED AND "Session start[Time stamp]" <=-6m order by created DESC