jql query return issues between two date fields

tom webb August 16, 2015

I have 2 custom date fields 'start date' and 'end date'

 

I need to return all issues where todays date is between the start and end date

 

I have tried start date >= startofday() and end date <= startofdate() however that doesnt return all the issues as sometimes there is no end date just a start date as its only for a 1 day period.

 

when i try to add or empty it returns everything even if there is a date in the end date or start date or if they are both empty.

 

i need to do something like this - startofday() between start date and end date

1 answer

0 votes
GabrielleJ
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 17, 2015

Try...

"Project = ABC and "start date" >= 2015-8-1 and "end date" <= 2015-8-3"

"Project = ABC and "start date" > 2015-7-31 and "end date" < 2015-8-1"

This might also help..

"Project = ABC and Status was "Open" During ("2015-8-1","2015-8-31")"

 

https://confluence.atlassian.com/display/JIRA/Advanced+Searching

Suggest an answer

Log in or Sign up to answer