Using ScriptRunner Post Function to set issue End Date to endOfMonth

Question

Hi, I´m trying to set up a post function script where the Enddate will be set to the end of the current month.

The actual script considers the currentdate value +30days.

Has anyone got an idea to change the +30 to endOfMonth?

import com.atlassian.jira.component.ComponentAccessor

import java.sql.Date

import java.sql.Timestamp

import com.atlassian.jira.ComponentManager

import com.atlassian.jira.issue.CustomFieldManager

import com.atlassian.jira.issue.fields.CustomField

import org.apache.log4j.Logger

import org.apache.log4j.Level

// Manager

CustomFieldManager customFieldManager = ComponentAccessor.getCustomFieldManager()

//Values

CustomField currentDate = customFieldManager.getCustomFieldObject("customfield_11808")

Timestamp currentDateValue = (Timestamp)issue.getCustomFieldValue(currentDate)

Date newDateValue = new Date(currentDateValue.getTime())

//Add 1 month

newDateValue.setMonth(currentDateValue.getMonth() +1)

//Update custom field

issue.setCustomFieldValue(currentDate, newDateValue.toTimestamp())

Jörg Friedmann · Answer

I guess not.

I tried some modifcations but failed, Im not able to adapt your code to mine.

ALso what I do not understand is how your code interacts with the condition to set the new date of the issue to 1month in future.

Maybe my explanation was bad. Background is I have a workflow where every issue set to done will be cloned to a new issue. This new issue shall have the end date value changed 1month forward automatically.

Orkun Gedik_ss6gzq · Answer

If you want to set all dates to the current month's last day, you don't need use currentDateValue. I missunderstood, forget what I said:)

By the way did you import the date libraries?

Jörg Friedmann · Answer

Hi Thanks a lot but I´m running on an error

Can ypu please explain what you mean with currentDateValue vaiable?

I changed the date format to dd-MM-yy also but without success