You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
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.
Hello @Mary M ,
David from ALM Works here.
For this, it is going to depend on what custom field you are using. If you are using a Date Picker custom field, it will be as I describe below. If you are using some other custom field type, or a custom field coming from another app, please let me know what that field is / where it comes from.
If using a Date Picker custom field, we will want to use the DAYS_BETWEEN function, defining your custom field and today(), then compare the "days between" to the 30 day threshold you have set.
It will look something like this:
You can change the "oh no" to match whatever text you would like to display.
I should also mention that the formatting of the formula will depend on which version of Structure you are currently on. This format works with 7.0 and higher. You can determine which version of Structure you are on by clicking on the info button in the bottom right corner of your structure.
Please let me know if this helps.