How to create a post function ScriptRunner script for advancing a custom Date Picker field by X days.

We have a workflow that has a transition for auto-advancing a custom Date Picker field by 21 days and need some guidance in creating the Post Function ScriptRunner script for advancing the date.

Many thanks for your willingness to assist.

2 answers

The example here explains how to update multiple custom field types:

Line 28/29 shows how to advance a date field by 7 days...

So removing what you don't need, you should end up with something like:

import com.atlassian.jira.component.ComponentAccessor
import java.sql.Timestamp

def customFieldManager = ComponentAccessor.getCustomFieldManager()

// a date time field - add 7 days to current datetime
def dateCf = customFieldManager.getCustomFieldObjectByName("First Date") // Date time fields require a Timestamp
issue.setCustomFieldValue(dateCf, new Timestamp((new Date() + 7).time))

Sir Jamie,

Good to hear from you.

Many thanks for your concrete tips!

Hello, @Jamie Echlin [Adaptavist]

Can you please explain instead of Timestamp, what would be needed if the date picker is only a date picker and not a date time picker?

Thank you in advance for your help. 

It's the same thing, it will just ignore/truncate the time portion.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Feb 07, 2019 in Marketplace Apps

A Timeless Love Story

It started as any story starts, on a normal, rainy day.   Admin meets App, and her name was Klok2, and like any first relationship we were both trying to make it work but neither one knew what...

468 views 8 27
Read article

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you