Forums

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

is possible a JQL to pick a date every year ( same date on 15 july)?

Dani Santa
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!
July 19, 2022

I have automation for a BAU in my company 

Weekly BAU-Monthly BAU-Quarterly BAU and also the Annually BAU. 

I use {{july.OfTheMonth(2, 5)}} and didn't work also I pick a date, but I assumed that date I should change every year manually.

Is there any JQL for this? 

 

1 answer

0 votes
Sayed Bares _ServiceRocket_
Community Champion
July 19, 2022

Hi Daniela,

The only way I can think of (without third-party apps) is using startOfYear(INC) function.

The issue with INC is that it only accepts a single parameter type Year/Month/Week .. (+/-)nn(y|M|w|d|h|m)

So the best way to do this is using days and 15th of July is exactly 195 days more than 1st of January. Thus, the following query should do the trick:

created >= startOfYear("195d") and created <= startOfYear("196d")

Best,

Sayed 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events