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

[Jeff Peters]

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.

[JamieA]

The example here explains how to update multiple custom field types: https://scriptrunner.adaptavist.com/latest/jira/recipes/workflow/postfunctions/set-issue-attributes.html

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

[Jeff Peters]

Sir Jamie,

Good to hear from you.

Many thanks for your concrete tips!

[kiranmai genkolla]

the above script is working fine for me . But the challenge for me is to exclude the weekens now .

Can anyone help me in this please .

my script :

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

def customFieldManager = ComponentAccessor.getCustomFieldManager()
def dateCf = customFieldManager.getCustomFieldObject("customfield_18761")
issue.setCustomFieldValue(dateCf, new Timestamp((new Date() + 7).time))
return dateCf

[Matt Tracy]

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. 

[JamieA]

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