Struggling with a specific JQL search

[Yasmine]

Hi Everyone, 

We have used JQL advance search a few times and it's great, but i am having a hard time with a specific one. I'm hoping someone has some insight on what i'm missing.

Search that i need: 
All standard issue types, in a specific project, and the status was in x on x day.

JQL i have so far: 
project = "PROJECT NAME" AND status was in ("STATUS")

Im having a hard time with the date and standard issue type portion

[Dirk Ronsmans · Accepted solution]

Hey @Yasmine ,

For the standard issue types that's an easy one, you can use 

AND issuetype in standardIssueTypes()

For the Status there should be a way to add it to the WAS operator

https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-operators/#Advancedsearchingoperatorsreference-WASWAS

There are a few examples on that link to the documentation. You could maybe use DURING and set 2 dates where it needs to fall between to get the exact date

[Yasmine]

Thank you for the link. That was really helpful. I actually ended up being able to use ON operator and ("YYYY/MM/DD"), and was able to run the exact advance search I needed. 

Thanks Again Dirk!