We need to create a filter with specific date and time criteria

Question

We have a requirement where we want to filter a Jira incidents with below criteria.

- Specify a start date and end date where the tickets will be shown only from 9am to 9pm of each day. (Ignoring night time tickets)
AND
- Ignoring incidents (ticket) which are already resolved and having false alarm.

Ashutosh Maheshwari · Answer

@PVS  It doesn't work. Please have a look at screen-shot below:

Query used by me - project = INCDT AND createdDate >= "2019-11-16 9:00" and createdDate <= "2019-11-21 21:00"

PVS · Answer

Yes  using this JQL createdDate >= "2019-11-16 9:00" and createdDate <= "2019-11-21 21:00"    Its Not showing the data ofter 9

Ashutosh Maheshwari · Answer

So, What @Sagar Ghuge is trying to say is, he needs to filter from one specific date lets say: 15th November to 21st November. But the tickets should be showing time from morning 9 AM to 9 PM only, so tickets of 8 AM or 10 PM should not be shown.