When using JQL to search for issues in a next-gen project, it doesn't work to do :
project='PN' AND status WAS IN ('In Progress') DURING('2020-03-06','2020-03-08')
But if you rename the name of the In Progress status in your board (and change it in your query) it works.
Step to reproduce :
This is a known bug, albeit not with all the specifics you mention - see JRACLOUD-72180. Worth adding them on there!
There is a workaround mentioned on this bug to search via Status ID rather than name - I've tried it and it seems to work - to do this:
Locate your Next-Gen project's ID:
Next locate your status' ID:
You can now search using the ID - eg. "Status was 101323".
Hello friends! From the community that brought you Welcome Wednesday, Throwback Thursday and Friday Fun, welcome to Taco Tuesday, a weekly discussion about all things Trello. The best part? One Tac...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events