JQL sentences about the resolutiondate before 3 months from today

[Nate _이슬기_ _Project Management_ _]

Dear Sir,

I am in stuck with this quiz as follows:

Quiz.

   Search the tickets which are resolved before 3months based on today.

   For example, there are 3 tickets (A,B,C)

      A: resolution date is 2018/11/01 (Over 3month)

      B: resolution date is 2018/12/01 (Over 3 month)

      C: resolution date is 2019/03/01 (under 1 month)

      Today: 2019-03-27

   So the corrected JQL should search only A,B

Anyone help please?

Regards,

Nate    

[Deleted user · Accepted solution]

Hello Nate  - There is nothing available in native JIRA that will let you write a JQL query with month mentioned. Days and Weeks is how far it goes. So, if you are ok to translate this to about 12 weeks, then your query can be -

(project = ABC AND Resolved <= -12w)

And if you were to do this in days, I would run something like this -

(project = ABC AND resolved <= startOfDay(-90d))

Please review this document for Advanced Searching functionality

Hope this helps!

Thanks

Kalyani