JQL returning active projects for the past 24months (2 years)

[romuald tchokothe]

For my Jira Software Projects:

1-I would like a JQL that return all the active projects for the last 24months (2 years)

2-I would like a JQL that return all the inactive project for the last 24months (2years)

Thanks

[Mikael Sandberg]

Hi @romuald tchokothe

Welcome to Atlassian Community!

JQL doesn't have a function that would do this for you, it is intended to search for issues, not projects. You can find project information, like the last time it was used if you go to Settings > Projects. You can also get this information via REST API and the Get projects paginated endpoint. 

[romuald tchokothe]

Thank you.  How can I create a JQL returning last project updated.?

Thanks

[Mikael Sandberg]

Short answer is no, JQL does not have a function that will do that.