We should look at adding timezone support to dates. This would allow the users to create dates that were consistent no matter where they are run. The main change will be to JQLDateSupport.ACCEPTED_FORMATS and the tests.

For example: 2008/09/12 GMT.Add time

Here is my scenario. We have Shift 1 in India and Shift 2 in USA. I write a query to find all tickets that are still open to let Shift 2 take over. When a Shift 1 person gives that query to a Shift 2 person it is 12.5 hours into the past, and is useless.

But if I could include a timezone, or at least specify to use server time zone that would fix it.

Copy of JRASERVER-59615

Here is my example query:

project = "Security Incidents" AND status was in ("Create", Detect, "In Progress",Analysis) during ("2018/11/27 18:30", "2018/11/28 02:30") AND "Assignment Group" in (Tier-1, Tier-2) AND status was not in (Closed,Validated) DURING ("2018/11/27 18:30", "2018/11/28 02:30")