Working with dates

Still need help?

The Atlassian Community is here for you.

Ask the community

You can manipulate and format created, updated, duedate, resolutiondate dates (as well as the Date Picker custom field) inside fields that support Smart Values. Date functions and attributes are in the date reference section.

Old syntax

For rules created prior to November 2018, refer to the old syntax documentation.

Formatting dates

You specify the format of a date at the end of the smart value: 

// using inbuilt formats
{{issue.resolutiondate.asLongDateTime}}
{{issue.MyDateFieldName.longDateTime}}
{{issue.created.jqlDateTime}}
{{issue.created.mediumTime}}
{{issue.Sprint.endDate.jiraDate}} - format the Sprint field's end date into a format suitable to set another field

// Or, you can specify the format
{{issue.dueDate.format("dd/MM/yyyy")}}
{{issue.created.as("dd MMM")}}

See our reference guide for a complete list of available date formats.

Locale (location based date format)

You can specify the locale to print the dates in (default is "US" locale). 

// Prints the issue's created date in French
{{issue.created.withLocale("fr").asLongDateTime}}

// Prints the issue's created date in French Canadian
{{issue.created.locale("fr_CA").longDateTime}}

// Prints the issue's created date in the locale of the reporter
{{issue.created.locale(issue.reporter.locale).longDateTime}}

For a list of locales, please refer to Java documentation.

Time zone

Dates are displayed in Jira's default timezone.

// Converts the issue's created time to the new timezone, 
// e.g. 10am UTC converts to 8pm AEST
{{issue.created.convertToTimeZone("Australia/Sydney")}}

// Converts the issue's created time to the new timezone and keeps the same
// times/dates. E.g. 10am UTC changes to 10am AEST
{{issue.created.setTimeZone("Australia/Sydney")}}

For a list of timezones, please refer to Java documentation.

Specify a user's timezone: 

// Prints the issue's created time in the reporters timezone.
{{issue.created.convertToTimeZone(issue.reporter.timeZone)}}

Manipulating dates

Manipulate dates by setting parts of the date or adding/subtracting values from it:

// Add 7 days to the current time
{{now.plusDays(7)}}
 
// You can chain functions
// Set the created date to November 1st
{{issue.created.withDayOfMonth(1).withMonth(11)}}

Attributes of a date

Retrieve individual attributes of a day, e.g. the month

// Get today's day of the month
{{now.dayOfMonth}}
 
// Get the day of the week the issue was created
{{issue.created.dayOfWeekName}}

// Get the day name of the week in French
{{issue.created.locale("fr").dayOfWeekName}}

Calculating business days

Plus/minus business days from the current date or find the closest business day to the current date. Business days are considered Monday through Friday.

// The next business day
{{now.toBusinessDay()}}

// The next business day after 3 days
{{now.plusDays(3).toBusinessDay()}}

// The previous business day
{{now.toBusinessDayBackwards()}}

// Adds 6 business days to today
{{now.plusBusinessDays(6)}}

// The first business day of the month
{{now.firstBusinessDayOfMonth}}

// The last business day of the month
{{now.lastBusinessDayOfMonth}}

// The number of business days beeween when the issue was created and today
{{now.diff(issue.created).businessDays}}

Calculating the difference between two dates

The "diff" method to calculate the difference between two dates by passing in another date and then specifying the unit to measure.

// Gets how many hours since an issue was created
{{now.diff(issue.created).hours}}

// Gets the number of days between two dates
{{now.diff(issue.created).days}}

// To show positive dates use the "abs" method
{{now.diff(issue.created).abs.days}}

Comparing two dates

You can compare two dates. These methods take another date as the parameter.

// Returns "true"
{{now.isAfter(issue.created)}}
tip/resting Created with Sketch.

Tip

Compare dates using the Compare condition.

Converting text to dates

When a date is text, e.g. in the changelog, dates are stored as text:

{{issue.summary.toDate}}

Convert the text to a date if it's in the right format. You can specify the format to convert from, by adding the param. The example below converts text, e.g. "2017 6 11", into a date object.

{{issue.summary.toDate("yyyy MM dd")}}

Once you've converted text to a Date object, you'll may need to transform it further, e.g. for a field changed (e.g. listening for a change in date)

{{fieldChange.fromString.toDate.plusDays(1).longDate}}

Referencing the current date/time

You can reference the current date and time using {{now}}

Example

// 1st of May this year
{{now.startOfMonth.withMonth(5)}}

// 1st of May next year
{{now.startOfMonth.withMonth(5).plusYears(1)}}

// last day of May
{{now.withMonth(5).endOfMonth}}

// first business day in May
{{now.withMonth(5).firstBusinessDayOfMonth}}

// last business day in May
{{now.withMonth(5).lastBusinessDayOfMonth}}
Last modified on Oct 26, 2021

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.