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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.