nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Glenn_2rtpns

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.

Accepted answers

Tarun Sapra

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)

All comments

Simple Tyler

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_2rtpns

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

Tarun Sapra

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_2rtpns

I got it. Thanks Tarun Sapra.

Glenn_2rtpns

Thanks Tyler!

Paul.j

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

Paul.j

The above query is really useful. How to get the same data for a week/month between 10 PM 5 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

Richard Cross

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

Yuliia_Borivets__SaaSJet_

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira