I'd like to ask for JQL advice.

[양재석]

I want to write JQL to search for a date that changes to a specific state, but I don't know how to write it.

[Robert Wen_Cprime_]

Hello @양재석 

I don't think you can use JQL to get the information you want.  JQL is used to find issues.

So to find issues that moved to STATUS on a specific date, you'd write 

status CHANGED to <STATUS> ON <DATE>

[양재석]

You were right
Thank you so much!

He saved me!

[Robert Wen_Cprime_]

Happy to hear! If you're all set, go ahead and mark the question as answered with accepted answer(s).

[Mark Higgins]

Hi,

JQL has functions that are useful for date range search, such as startofday(), endofmonth(), and these functions can take parameters, such as startofmonth(-3), which gives you everything regarding 3 months ago.

I'm not sure what you mean by 'state', as I'm in Australia, and state is the area of the country?

Happy to get more details?

Mark

[양재석]

Thank you for your reply, Mark.

"STATE" I meant "STATUS" in JIRA.

If there is data that has been moved to STATUS in the past, not the data currently in STATUS, I want the date when that data was moved.

[Yuliia_Borivets__SaaSJet_]

Hi @양재석 

JQL works with WAS or CHANGED operators to find status changes. Here you can try something like:

status CHANGED TO "Done" DURING ("2023/03/01","2023/04/01")  

I'm not sure if you can search for the date when the issue changed its status.

Maybe this article will be helpful, too:

6 simple options to track status changes in Jira