Set a date two months after the end of the quarter

Use case

Configure a calendar with the dates of the ends of the quarters and set automatically a date in a Date Picker field two months after the closest one.

Prerequisites

Create a Calendar named End of Quarters with the following specification:

Bash

MAR/31, JUN/30, SEP/30, DEC/31 {

08:00 - 09:00;

}

You can change the dates to specify when the quarters or the business periods end.

🛠️ 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

Use the following expression in with the expression editor in Numeric mode

Bash

addMonths(nextTime({system.currentDateTime}, "End of Quarter", LOCAL),2, LOCAL)

You can modify the number of months added to the date by replacing the number 2 in the expression with the amount of numbers that you need to add.

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