Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

using jql, can I search the by projects but limit the updated filed to a date or a month or year

Robert Williamson - NOAA Affiliate
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
September 22, 2024

Current Query searches all projects:

ORDER BY updated DESC, created DESC, key DESC

updated field looks like this for one ticket: 

 

Sep/22/2024 

What if I wanted only 2024 or only September of 2024?

1 answer

1 accepted

0 votes
Answer accepted
Evgenii
Community Champion
September 22, 2024

Hi, @Robert Williamson - NOAA Affiliate 

Welcome to Atlassian Community.

You can search using date limits in query. It looks like:

updated >= "2024/09/01" and updated <= "2024/09/30"


Or, if you want to limit by relative limits, you can use:

updated >= startOfMonth() AND updated <= endOfMonth()

You can read about this limits here:
JQL functions

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events