nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Cannot use date calculations in JIRA

jmartin3

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.

<-30d

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

Comments

Payne

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

created <= -30d

jmartin3

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

Screenshot 2021-05-27 134436.png

Payne

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

Support Team [ALM Works]

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

jmartin3

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

Support Team [ALM Works]

@jmartin3 ,

So glad to hear it helped!!

Best,
David
www.almworks.com

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-server

structure

addon-com.almworks.jira.structure

jql

date