How Can I write JQL for creation time between timestamp?

Question

Hi all, I want to filter the ticket which are created between Night time for the whole year?

Such as,

Date : 2023-01-01 ~ 2023-12-31

Ticket Created Timestamp : 18:00 ~ Next day 08:00

Can I get that data?

I used the startOfDay but I can only get one day data, I need to get whole year.

Please help me!

Thanks in advance!

Asmath Basha S · Answer

Hi @Nam Dong Yeon ,

In Jira you can't filter the tickets for a specific time for the last 1year. Only by specifying each day separately you can find the tickets created for 1day.

But unfortunately this feature is not available in JQL.

Alan Stephenson · Answer

True, you are correct. I checked some more and there isn’t one JQL to do what you want. You can possibly do something like what was outlined here;

https://community.atlassian.com/t5/Jira-Software-questions/JQL-for-time-range/qaq-p/1639572

the last line shows how you can do a single day to a partial following day.

I haven’t tested since I’m not in front of a Jira system but it looks like it might work. To do every single day would be hard to do because there is no time range that will do what you are trying. But I will try and report back to you.

Nam Dong Yeon · Answer

I think my question is different with ur answer.

My means that I want to get all ticket which was created at night time (18:00~Tomorrow 08:00) during the year.....

Thanks!