Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Cannot use date calculations in JIRA

We are trying to create some structure groupings based on dynamic dates, basically if the JIRA was created more than 30 days ago.


We tried each of the following and all came back with a "cannot parse" error message.  




We are using JIRA 8.5.9, so I am not sure if it is a version issue or syntax.


Payne Rising Star May 27, 2021

You're on the right track; try this in the search:

created <= -30d

thanks!  It works fine in JQL but won't work in Formula

Screenshot 2021-05-27 134436.png

Payne Rising Star May 27, 2021

Ah, OK; this looks to be some sort of add-on that I'm not familiar with. Sorry.

Hello @jmartin3 ,

David from ALM Works here.  

Based on the goal you describe, you should be able to accomplish this by adding a formula column to your structure and then grouping the issues by the result.  Expr language is the Structure feature used to write formulas within a structure.

Here is an example formula you may be able to use for your purpose.

IF(days_between(created,today())< 30;"Recent";"Old")

Basically if the days between when the issue was created and "today" are less than 30, it will show "recent" in the column and "old" if days between are greater than 30.

You can expand the number of conditions and results as well.  This is covered in the Expr Function Reference doc I linked above.

Once you have the Formula in place and returning the results you want, the next step is to add a Group Generator.  

You will want to Group by Text Attribute specifically.  Pick your new Formula column from the "Group By" drop-down list and you should be in business.

I have made some assumptions here, so if this is not what you are looking to do, or you have any additional questions, please feel free to contact our support team directly!  We can be reached through our service portal,, or email via

I look forward to your feedback!


Like # people like this


I was able to adapt the equation you provided into the specific use case needed and it works like a charm.  It was the "today()" aspect that I could not figure out.


Thank you for the quick responses

@jmartin3 ,

So glad to hear it helped!!  



Log in or Sign up to comment