Versions Compared

Key

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


Page properties
hiddentrue
Status
Tech review

Status
colourGreen
titledone

Style guide

Status
colourGreen
titledone

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

Page properties
hiddentrue
Short description

Returns the timestamp of any given date in text form

Output Statussubtletruetitletext UI Text Box
sizemedium
typeinfo

Returns This function returns the full timestamp (date and time) of any given date in text form


Code Block
languagebash
titleSyntax
linenumberstrue
dateTimeToString(timestamp, timeZone, language) #Output: Text


UI Expand
titleExamples


Parser ExpressionDescription


Code Block
languagebash
linenumberstrue
dateTimeToString({issue.created}, LOCAL, USER_LANG)


This example

will take the timestamp (date-time in milliseconds) and translates it to a user friendly text, displayed in the entered language's format.

could return:

18/May/20 7:52 AM



UI Expand
titleAdditional information

Parameters used in this function

ParameterInput (data type)Description
timestamp

Status
subtletrue
titlenumber

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

Status
subtletrue
titletimezone

The time zone used for the conversion. 

language

Status
subtletrue
titleLanguage

The language used for the conversion. 



UI Expand
titleOutput

The This function returns a

Status
subtletrue
titletext
.




UI Text Box
typetip

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

UI Text Box
sizemedium
typeinfo

Variant where you can additionally define a custom date time pattern (see documentation).


Code Block
languagebash
titleSyntax
linenumberstrue
 dateTimeToString(timestamp, dateTimePattern, language) #Output: Text


UI Expand
titleExample


Parser expressionDescription


Code Block
languagebash
linenumberstrue
dateTimeToString({issue.created}, "yyyy.MM.dd 'at' HH:mm:ss", USER_LANG)


This function takes the issue's creation date (in milliseconds) and converts it to a text by using the given date time pattern.example could return:

2020.05.18 at 07:52:02



UI Expand
titleAdditional information

Parameters used in this function

ParameterInput (data type)Description
timestamp

Status
subtletrue
titlenumber

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

Status
subtletrue
titletext

A Java date time pattern in text form according to the Java Date time patternpattern (see documentation).

language

Status
subtletrue
titlelanguage

The language used for the conversion. 



UI Expand
titleOutput

The This function returns a

Status
subtletrue
titletext
.




UI Text Box
typetip

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

UI Text Box
sizemedium
typeinfo

Variant where you can specify a custom format according to the date time pattern pattern and additionally a time zone (see documentation).


Code Block
languagebash
titleSyntax
linenumberstrue
 dateTimeToString(timestamp, dateTimePattern, timeZone, language) #Output: Text


UI Expand
titleExamples


Parser expressionDescription


Code Block
languagebash
linenumberstrue
dateTimeToString(0, "yyyy.MM.dd 'at' HH:mm:ss", GMT, USER_LANG)


This example returns:

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


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


This example returns:

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



UI Expand
titleAdditional information

Parameters used in this function

ParameterInput (data type)Description
timestamp

Status
subtletrue
titlenumber

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

Status
subtletrue
titlenumbertext

A Java date time pattern in text form according to the Java Date time pattern (see documentation).
timeZone

Status
subtletrue
titletimezone

The time zone used for the calculation. 

language

Status
subtletrue
titlelanguage

The language used for the conversion. 



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

The This function returns a

Status
subtletrue
titletext
.

UI Text Box
typetip



Image AddedUse cases and examples

Page properties report
firstcolumnUse case
headingsJWT feature, Workflow function, Field type, Automated action, Parser functions
cqllabel = "parser_func_datetimetostring" and space = currentSpace()


Page properties
hiddentrue
id1


Parser function clouddateTimeToString()
Map(tick)
Notes




Page properties
hiddentrue



Status
Tech review

Status
colourGreen
titledone

Style guide

Status
colourGreen
titledone

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



Page properties
hiddentrue


Short description

Returns the timestamp of any given date in text form

Output

Status
subtletrue
titletext

Available since

Status
subtletrue
colourBlue
title2.4.0

Label

Status
colourRed
titlestaff pick