Jira smart values - date and time
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}}
Format | Thursday, November 1, 1979 6:23:12 AM EST |
---|---|
Default (none specified) | Nov 1, 1979 6:23:12 AM |
jiraDate | 1979-11-01 |
jiraDateTime | 1979-11-01T06:23:12.0-0500 |
jqlDate | 1979-11-01 |
jqlDateTime | 1979-11-01 06:23 |
shortDate | 11/1/79 |
shortTime | 6:23 AM |
shortDateTime | 11/1/79 6:23 AM |
mediumDate | Nov 1, 1979 |
mediumTime | 6:23:12 AM |
mediumDateTime | Nov 1, 1979 6:23:12 AM |
longDate | November 1, 1979 |
longTime | 6:23:12 AM EST |
longDateTime | November 1, 1979 6:23:12 AM EST |
fullDate | Thursday, November 1, 1979 |
fullTime | 6:23:12 AM EST |
fullDateTime | Thursday, 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 |