Get started

Use case library

JWT expression editor

JWT expression parser functions

JWT workflow functions

JWT remote actions

JWT automation rules

JWT calculated fields

JWT calendars

JWT properties

JWT JQL functions

Cloud migration hub

Additional product info

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 9 Next »

The function returns a TEXT representing the date-time value at t, in a certain time zone and a certain language.

This function is useful in the Action Update Field to represent as a text the result of a time expression.

Syntax
dateTimeToString(number t, timeZone time_zone, language) #Output: Text
Examples


Additional information

Parameters used in this function

ParameterInput (data type)Description
timestamp

NUMBER

The parameter must be valid timestamp. Usually this value is retrieved from a field (e.g. due date, created date).
numberOfDays

NUMBER

The number defined here will be the offset in days. 

Negative values are used to substract days.

Internally JWT multiplies this value with the time macro  {DAY} to add full days to the timestamp. Learn more about time macros.

timeZone

TIMEZONE

The time zone used for the calculation. 

Work days might depend on the time zone - it might be Sunday on the west coast of the US while at the same time it's already Monday in Australia. 

Output

The function returns a TEXT


The function returns a TEXT representing the date-time value at t with a certain custom format defined by date_time_pattern text parameter, using a certain language for months, days of the week, etc.

This function is useful in Action Update Field to represent as a text the result of a time expression.

Syntax
 dateTimeToString(number t, string date_time_pattern , language) #Output: Text
Example
Parser expressionDescription
dateTimeToString(2011-03-25 11:30, "yyyy.MM.dd 'at' HH:mm:ss", USER_LANG)

The function will return a TEXT : "2011.03.25 at 11:30:00"


Additional information

Parameters used in this function

ParameterInput (data type)Description
timestamp

NUMBER

The parameter must be valid timestamp. Usually this value is retrieved from a field (e.g. due date, created date).
numberOfDays

NUMBER

The number defined here will be the offset in days. 

Negative values are used to substract days.

Internally JWT multiplies this value with the time macro  {DAY} to add full days to the timestamp. Learn more about time macros.

timeZone

TIMEZONE

The time zone used for the calculation. 

Work days might depend on the time zone - it might be Sunday on the west coast of the US while at the same time it's already Monday in Australia. 

Output

The function returns a TEXT


The function returns a TEXT representing the date-time value at t with a certain custom format defined by date_time_pattern text parameter, in a certain time_zone using a certain language for months, days of the week, etc.

This function is useful in Action Update Field to represent as a text the result of a time expression.

Syntax
 dateTimeToString(number t, string date_time_pattern , timeZone time_zone, language)
Examples
Parser expressionDescription
dateTimeToString(0, "yyyy.MM.dd 'at' HH:mm:ss", GMT, USER_LANG)

The function will return a TEXT: "1970.01.01 at 00:00:00"

dateTimeToString(0, "yyyy.MM.dd 'at' HH:mm:ss", MST, USER_LANG)

The function will return a TEXT: "1969.12.31 at 17:00:00"

Additional information

Parameters used in this function

ParameterInput (data type)Description
timestamp

NUMBER

The parameter must be valid timestamp. Usually this value is retrieved from a field (e.g. due date, created date).
numberOfDays

NUMBER

The number defined here will be the offset in days. 

Negative values are used to substract days.

Internally JWT multiplies this value with the time macro  {DAY} to add full days to the timestamp. Learn more about time macros.

timeZone

TIMEZONE

The time zone used for the calculation. 

Work days might depend on the time zone - it might be Sunday on the west coast of the US while at the same time it's already Monday in Australia. 

Output

The function returns a TEXT