jql query return issues between two date fields

Question

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

unknown · Answer

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