JQL to get date within 3 months

[Narsha Bac]

Hello Team,

I am working on an automation rule where I need to compare two dates. I have a custom field named 'Baseline start date'. If this date is within the next 3 months, I need to transition the issue. 

For example, if I insert the date 06/08/2023 and today is 02/08/2023, I need to compare it with the smart value or a JQL to know if this is within the next 3 months. If today is 02/08/2023 and I insert the date 02/02/2024, it should not transition my issue since February is not within 3 months.

I can do this by a JQL or by comparing the custom field with a smart value.

Any help on this please?

Thanks.

[Matthias Gaiser _K15t_ · Accepted solution]

Hi @Narsha Bac

you can use a JQL with relative dates/times. So, in your case you could build a JQL like:

"Baseline start date" > now() and "Baseline start date" < 90d

Would this help?

Cheers,
Matthias.

[Narsha Bac]

This works. Thanks a lot!

Cheers.