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
"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")"
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG