how can I create a jql filter with time range between two dates

[Glenn]

Hi 

Is there a way I could filter an issue within a specific time but also it has an interval date?

Something like this:

Night Tickets

project = SO AND created > "2017/11/20 22:00" AND created < "2017/11/21 6:00"

I would like to know the number of tickets by night within a single day.

[Tarun Sapra · Accepted solution]

Hello Glenn,

For dynamic dates , you can do something like

project = SO and created > startOfDay("-2h") and createdDate <  startOfDay("+5h")

 This will give you night tickets for every day. I.e. tickets created between 10 pm (last day) and 5 am (of current day) 

[Glenn]

I got it. Thanks  Tarun Sapra. 

[Paul.j]

The above query is really useful. How to get the same data for a week/month between 10 PM 5 AM?

[Richard Cross]

what's the difference between "created" and "createdDate"?

[Dave Liao]

@Richard Cross - there's no difference, one's an alias (but don't ask me which one!). 😅

If you have any other questions, definitely start a new thread on Community! (Click Ask the community in the header).

[Tyler Brown]

Hey Glenn,

You certainly can, just use:

createdDate >= "2017-11-16 14:00" and createdDate <= "2017-11-16 23:00"

That should give you the tickets created during the specific time window you are looking for.

Hope this helps,

Tyler

[Glenn]

Ohh I forgot to mention the current date must be dynamic upon creation of ticket

[Glenn]

Thanks Tyler! 

[Paul.j]

How to get last one week/month ticket created between 10 PM to 8 AM?

[Yuliia_Borivets__SaaSJet_]

Hi @Paul.j 

I'm not the JQL expert, but the following query works for me:

project = ProjectName and created >="yyyy/MM/dd 10:00" AND created <="yyyy/MM/dd 08:00"

Hope this helps.

Best regards

[Sylvain Leduc]

Hello, not sure what you meant but writing 

created >="yyyy/MM/dd 10:00" AND created <="yyyy/MM/dd 08:00"

does not work : you have to specify year/month/day or else use startofday() etc 

[Yuliia_Borivets__SaaSJet_]

Yes, you should specify year/month/day. That was only an example.