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 filter with time range between two dates and hours

Horia Chiornita

Hi,

I would like to have an automatic filter that display all the tickets that have Activity Start Date and Activity End Date since yesterday starting with 8 am and ending with tomorrow at 8 am.

E.g.: today 4/ March i want to receive all tickets with Activity Start Date and Activity End Date between 3 March 8 am - 5 March 8am.

Now i have every day to select manually the dates and hours and probably it can be somehow automatically filled in JQL

Accepted answers

All comments

Alexey Matveev

Hello,

Try a JQL query like this:

("Activity Start Date" > startOfDate(-16h) and "Activity Start Date" < endOfDate(8h)) or ("Activity End Date" > startOfDate(-16h) and "Activity End Date" < endOfDate(8h))

Horia Chiornita

I'm working on it, Thank you!

I will update you if is working

Horia Chiornita

Unable to find JQL function 'startOfDate(-16h)'.
Unable to find JQL function 'endOfDate(8h)'.

This is the error received

Alexey Matveev

It should be like this:

("Activity Start Date" > startOfDay(-16h) and "Activity Start Date" < endOfDay(8h)) or ("Activity End Date" > startOfDay(-16h) and "Activity End Date" < endOfDay(8h))