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

Posted by Shevek on Stack Overflow See other posts from Stack Overflow or by Shevek
Published on 2010-04-26T13:27:56Z Indexed on 2010/05/16 18:50 UTC
Read the original article Hit count: 531

Filed under:
|
|
|
|

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?

© Stack Overflow or respective owner

Related posts about jira

Related posts about jql