JIRA JQL searching by date - is there a way of getting Today() (Date) instead of Now() (DateTime)

date search jira jql
Shevek picture Shevek · Apr 26, 2010 · Viewed 156.3k times · Source

I am trying to create some Issue Filters in JIRA based on CreateDate.

The only date/time function I can find is Now() and searches relative to that, i.e. "-1d", "-4d" etc.

The only problem with this is that Now() is time specific so there is no way of getting a particular day's created issues.

i.e. Created < Now() AND Created >= "-1d"

when run at 2pm today will show all issues created from 2pm yesterday to 2pm today
when run at 9am tomorrow will show all issues created from 9am today to 9am tomorrow

What I want is to be able to search for all issues created from 00:00 to 23:59 on any day. Is this possible?

Answer

Rob Allen picture Rob Allen · Jul 8, 2011

Check out startOfDay([offset]). That gets what you are looking for without the pesky time constraints and its built in as of 4.3.x. It also has variants like endOfDay, startOfWeek, startOfMonth, etc.

Related questions

Glob search files in date order?

I have this line of code in my python script. It searches all the files in in a particular directory for * cycle *.log. for searchedfile in glob.glob("*cycle*.log"): This works perfectly, however when I run my script to …

Read More
CakePHP Search between 2 Date Records

I am building a small Web App that lets users reserve Office Rooms and Equipment. For the Reservation they enter a Start and an End Date. When a user tries to find out if any (for example) car is available …

Read More
SEARCH BEFORE/AFTER with Pythons imaplib

I have a smaller IMAP-script written i Python(3.2). I my search-line looks like this: typ, data = M.search(None, 'FROM', '"MyName"') I get the expected results. However, if I change it to something like: typ, data = M.search(…

Read More