jql query return issues between two date fields

[tom webb]

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

[Deleted user]

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