Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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.  

{{now}}

{{#now}}

<-30d

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

2 comments

Payne Community Leader 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 Community Leader 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, support.almworks.com, or email via support@almworks.com.

I look forward to your feedback!

Best,
David
www.almworks.com

Like # people like this

OUTSTANDING!!!

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!!  

Best,
David
www.almworks.com

Comment

Log in or Sign up to comment
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you