The following smart values are available to access and format date and time fields. 

now

Smart value to reference the current date and time:

{{now}}
{{now.plusDays(7).jqlDate}}

Date formats

For example:

{{now.jiraDate}}
{{now.format("dd/MM/yyyy")}}
{{now.shortDate}}
FormatThursday, November 1, 1979 6:23:12 AM EST
Default (none specified)Nov 1, 1979 6:23:12 AM
jiraDate1979-11-01
jiraDateTime1979-11-01T06:23:12.0-0500
jqlDate1979-11-01
jqlDateTime1979-11-01 06:23
shortDate11/1/79
shortTime6:23 AM
shortDateTime11/1/79 6:23 AM
mediumDateNov 1, 1979
mediumTime6:23:12 AM
mediumDateTimeNov 1, 1979 6:23:12 AM
longDateNovember 1, 1979
longTime6:23:12 AM EST
longDateTimeNovember 1, 1979 6:23:12 AM EST
fullDateThursday, November 1, 1979
fullTime6:23:12 AM EST
fullDateTimeThursday, November 1, 1979 6:23:12 AM EST
format("<pattern>") e.g. format("dd/MM/yyyy")

Please refer to Java documentation for pattern syntax.
01/11/1979

diff(date)

{{now.diff(issue.created).days}}

Units available:

  • millis
  • seconds
  • minutes
  • hours
  • days
  • weeks
  • months
  • years
  • businessDays
  • prettyPrint
  • abs

"prettyPrint" displays the difference in words. E.g. 2 days 3 hours

isAfter(date)

{{now.isAfter(issue.created)}} (returns true/false)

isBefore(date)

{{now.isBefore(issue.created)}} (returns true/false)

isEquals(date)

{{now.isEquals(now)}} (returns true/false)

compareTo(date)

{{now.compareTo(issue.created)}} (returns number)
{{issue.created.compareTo(now)}} (returns number)
{{now.compareTo(now)}} returns 0

plusDays / minusDays

{{now.plusDays(1)}}
{{now.minusDays(1)}}

plusHours / minusHours

{{now.plusHours(1)}}
{{now.minusHours(1)}}

plusWeeks / minusWeeks

{{now.plusWeeks(1)}}
{{now.minusWeeks(1)}}

plusMillis / minusMillis

{{now.plusMillis(1)}}
{{now.minusMillis(1)}}

plusMinutes / minusMinutes

{{now.plusMinutes(1)}}
{{now.minusMinutes(1)}}

plusMonths / minusMonths

{{now.plusMonths(1)}}
{{now.minusMonths(1)}}

plusSeconds / minusSeconds

{{now.plusSeconds(1)}}
{{now.minusSeconds(1)}}

plusYears / minusYears

{{now.plusYears(1)}}
{{now.minusYears(1)}}

plusBusinessDays/minusBusinessDays

Business days are considered to be Monday to Friday, 9am to 6pm.

{{now.plusBusinessDays(1)}}
{{now.minusBusinessDays(1)}}

toBusinessDay/toBusinessDayBackwards

Business days are considered to be Monday to Friday, 9am to 6pm.

{{toBusinessDay}}
{{toBusinessDayBackwards}}

setTimeZone / convertToTimeZone

{{convertToTimeZone("Australia/Sydney")}}
Converts the time to what it would be in the new timezone. E.g. 7am UTC will become 5pm Sydney time. This is useful when wanting to print dates in a specific timezone or perform calculations based on the hours of a specific timezone.

{{setTimeZone("Australia/Sydney")}}
Changes the timezone but maintains the same date/time. e.g. 7am UTC will get converted to 7am Sydney time

Note: Timezones must be supplied in the {area}/{city} format e.g. America/Los_Angeles

To date with time conversion

The following functions can be used to convert a date to a date with a time component:

{{now.toStartOfDay}}
{{now.toCurrentTime}}
{{now.toDateTimeAtStartOfDay}}
{{now.toDateTimeAtStartOfDay(timezone)}}
{{now.toDateTimeAtCurrentTime}}
{{now.toDateTimeAtCurrentTime(timezone)}}

withDayOfMonth

{{now.withDayOfMonth(15)}}

withNextDayOfWeek

Sets the date to the next matching day.
If you're already on that day, then it will return the next week.
You can use one of these as values: MON, TUE, WED, THU, FRI, SAT, SUN.

{{now.withNextDayOfWeek("TUE")}} will return the next Tuesday
{{now.withNextDayOfWeek("MON").withHour(14).withMinute(0)}} will return the next Monday at 2pm

withHour

{{now.withHour(20)}}

withMillis

{{now.withMillis(500)}}

withMinute

{{now.withMinute(59)}}

withMonth

{{now.withMonth(10)}}

withSecond

{{now.withSecond(0)}}

withYear

{{now.withYear(1979)}}

withDayOfYear

{{now.withDayOfYear(355)}}

Set the day component of the date

{{now.endOfMonth}}
{{now.startOfMonth}}
{{now.firstBusinessDayOfMonth}}
{{now.lastBusinessDayOfMonth}}

// Parameters: day of week (1-7) 
{{now.firstOfTheMonth(1)}}
{{now.lastOfTheMonth(1)}}

// Parameters: nth of month (1-5), day of week (1-7)
{{now.ofTheMonth(2, 1)}}

Attributes

Attributes
millis
second
minute
hour
dayOfMonth
monthOfYear
year
dayOfYear
dayOfWeek
dayOfWeekName
dayOfWeekShortName
weekOfYear
zoneId
toDays
isLeapYear
lengthOfMonth
lengthOfYear
timeZoneShort
timeZoneFull
timeZoneNarrow
offsetShort
offsetFull
offsetNarrow
  • No labels