Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Page properties
hiddentrue



Status
Tech review

Status
titletodo

Style guide

Status
titletodo

Status
titletodo
Status
colourYellow
titleReady for review
Status
colourGreen
titledone
Status
colourRed
titleflagged



UI Text Box
sizemedium
typeinfo

All date-time values are numeric values representing the number of milliseconds elapsed since January 1, 1970, 00:00:00 GMT.

JWT offers various ways of displaying or calculating with date-time values.

JWT calculated number fields

Dates, times and time zones (function list)


Time Macros

Macros are aliases for literal / fixed values. A comprehensive set of time macros is provided to make your expressions more readable.

MacroEquivalent value
{SECOND} 1000
{MINUTE} 1000 * 60
{HOUR} 1000 * 60 * 60
{DAY} 1000 * 60 * 60 * 24
{WEEK} 1000 * 60 * 60 * 24 * 7
{MONTH} 1000 * 60 * 60 * 24 * 30
{YEAR} 1000 * 60 * 60 * 24 * 365


The following macros return the day of the week:

Macro Equivalent value
{SUNDAY} 1
{MONDAY} 2
{TUESDAY} 3
{WEDNESDAY} 4
{THURSDAY} 5
{FRIDAY} 6
{SATURDAY} 7


UI Text Box
typetip

Use these macros in the following functions:

dayOfTheWeek()

dayOfTheWeekToString()

dayOfTheMonth()

dayOfTheYear()



The following macros return the month:

MacroEquivalent value
{JANUARY} 1
{FEBRUARY} 2
{MARCH} 3
{APRIL} 4
{MAY} 5
{JUNE} 6
{JULY} 7
{AUGUST} 8
{SEPTEMBER} 9
{OCTOBER} 10
{NOVEMBER} 11
{DECEMBER} 12


UI Text Box
typetip

Use these macros in the following functions:

month()

monthToString()

Time zones

Fields of type date and date-time contain a numeric value with the milliseconds elapsed since January 1, 1970, 00:00:00 GMT.

The number that will be returned by any function using a date or date-time timestamp depends on a time zone.

The following time zones are currently available in JWT:

Time zoneOutput
LOCAL or SERVER_LOCALReturns the time zone configured for the server running Jira.
USER_LOCALReturns the time zone of the current user.
RUN_AS_LOCALReturns the time zone of the selected Run as user.


Languages

When dealing with times and time zones sometimes you need to convert them to text. The text returned depends on the selected language.

Currently JWT offers the following language parameters:

Time zoneOutput

SERVER_LANG

Returns the default language configured for the server running Jira.

USER_LANG

Returns the language of the current user.

RUN_AS_LANGReturns the language of the selected Run as user.