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 to filter/query for dynamic date/time

kevin jamieson1

I'd like to create a filter that grabs records where the resolutiondate < 12AM that morning.

resolutiondate < -1d gets me part of the way there, however bugs resolved less than 24 hours ago, but still on yesterday's date, will not show up until after the time they were resolved the previous day.

resolutiondate < "-1d 8h" gets me pretty close, but I'd like to be able to supply a date/time parameter.

So anything where I can assign a value to just the time, use a calculation in the query (-1d + datediff between now and midnight), or even just truncate the time from a date would work.

Thanks.

Accepted answers

Mikael Löwenadl

Not quite sure what you are after.

How about ... resolutiondate < now() and resolutiondate >= startOfDay()

That would get the ones resloved by midnight. You could use startOfDay("-1d") instead if you want to include the ones for the previous day as well.

All comments

Jeff Kirby

This is unfortunately not possible in Jira. It could be done by introducting a new JQL date function function, I suppose. Something like resolutiondate < timeSince("0")

Mikael Löwenadl

Not quite sure what you are after.

How about ... resolutiondate < now() and resolutiondate >= startOfDay()

That would get the ones resloved by midnight. You could use startOfDay("-1d") instead if you want to include the ones for the previous day as well.

kevin jamieson1

startOfDay() would totally have worked, but JQL doesn't seem to like it.

Unable to find JQL function 'startOfDay()'.

Mikael Löwenadl

I guess startofDay() was introduced in Jira 4.3 so if you have an earlier version that wouldnt work.

You could always write a report plugin, should be quite simple.

Welcome!

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

Quick Links

Find more posts tagged with

jira