Versions Compared

Key

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


Page properties
hiddentrue
Status
Tech review

Status
colourYellow
titleReady for review

Style guide

Status
colourYellow
titleReady for review

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

Page properties
hiddentrue
Short description

Returns 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

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

example 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 translationconversion

language

Status
subtletrue
titleLanguage

  •  Christian Czaia do we already have some explanation for the language parameter?

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

The function returns any given date in text form with a custom format according to the 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 translates 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
.




tip
UI Text Box
type

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

The function returns any given date in text form with a Variant where you can specify a custom format according to the date time pattern. Additionally you can specify 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 a

Status
subtletrue
titletext
: "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 a

Status
subtletrue
titletext
: "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