Forums

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

Date calculation in Jira Structure formula

Mary M
August 4, 2022

I am trying to create a Jira Structure Formula field that tells me if a date in a custom field is older than 30 days from today. 

I can get today's serial number and add 30 days of seconds to it, but when I try to take this little formula (today()+2592000) and use it anywhere else, it doesn't work as expected. I can do this:  format_datetime((today()+2592000),"dd-MM-yy") and it gives me today's date.  Taking out the addition gives the same result.

I have tried a number of different formulas and ways to break it down, with no luck.

Any ideas?

 

 

 

1 answer

0 votes
Alexey Matveev
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Champions.
July 9, 2018

Hello,

JQL can return only issues. It can not return to you a list of reporters. That is why you would need a plugin to accomplish your task. For example, Power Scripts or ScriptRunner.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events