Set a Date Picker field to the nth day of the month

Use case

Set a Date Picker field to the nth day of the month after the issue has been transitioned.

Configuration

Add the Update or copy field values post function to the transition of your choice.

Target issue

Choose Current issue

Fields

Field

Choose a Date Picker field

Value

Choose Set field value manually

Expression

Introduce the following expression in the expression editor in Numeric mode.

addDays({system.currentDateTime}, (10 - dayOfTheMonth({system.currentDateTime}, LOCAL)), LOCAL)

You can modify the day of the month that the Date Picker field will be set to by updating the number 10 in the previous expression.

Variant

The following expression will set the Date Picker field to the 10th day of the month if the issue is transitioned from the day 1 to the day 9 of the month, to the 20th day of the month if it is transitioned from the day 10 to the day 19, and to the last day of the month after the day 20 of the month.

dayOfTheMonth({system.currentDateTime}, LOCAL) < 10 ? 
addDays({system.currentDateTime}, (10 - dayOfTheMonth({system.currentDateTime}, LOCAL)), LOCAL)  :
(dayOfTheMonth({system.currentDateTime}, LOCAL) < 20 ? 
addDays({system.currentDateTime}, (20 - dayOfTheMonth({system.currentDateTime}, LOCAL)), LOCAL) : 
lastDayOfTheMonth({system.currentDateTime}, LOCAL))

Related use cases

Use case	Workflow function	Parser functions
Add days skipping weekends and holidays to a Date Picker field	Update or copy field values	addTime()
Add or remove request participants	Update or copy field values
Add watchers ignoring inactive users	Update or copy field values	usersInGroup() isActive() toString() filterByPredicate()
Assign important issues to the project lead	Update or copy field values
Assign issue to current user	Update or copy field values
Automatically fill an insight custom field after a transition	Update or copy field values
Change the assignee to the next evaluator	Update or copy field values	first() toStringList()
Create an internal Service Management comment on linked issues	Update or copy field values
Keep parent issue's priority in sync	Update or copy field values
Keep track of important status updates	Update or copy field values Fields required or changed	dateTimeToString()
Match several values of a list	Update or copy field values	toString() distinct() filterByPredicate()
Prioritize the issues globally	Update or copy field values	indexOf() previousValue() issuesFromJQL()
Set a date on the same week day on alternate weeks	Update or copy field values	addDays() nextDayOfTheWeek() modulus() weekOfTheYear() datePart()
Set a Date Picker field to the nth day of the month	Update or copy field values	dayOfTheMonth() lastDayOfTheMonth() addDays()
Set assignee based on a former assignee	Update or copy field values	previousValue()
Set Due Date with latest value among sub-tasks	Update or copy field values	fieldValue() max() siblingSubtasks()
Set fix version based on its start and release date	Update or copy field values	toString() textOnStringList() unreleasedVersions() startDates() releaseDates() first()
Set the next fix version	Update or copy field values	floor() toNumber() substring() length()
Shorten the summary to a maximum number of characters	Update or copy field values	substring() length()

If you still have questions, feel free to refer to our support team.

Content

Space Tools

On this page