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

Versions Compared

Old Version 4

changes.mady.by.user Iheb Kharab

Saved on

compared with

New Version Current

changes.mady.by.user Iheb Kharab

Saved on

Key

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


UI Text Box
sizemedium
typeinfo

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

Page properties
hiddentrue
Returns a representing the date-time value at t, in a certain time zone and a certain language.Outputtext
Short description

Status
subtletrue
title

text

timezone

The time zone used for the conversion. 

language

Status
subtletrue
title

Language

The language used for the conversion. 



ui-text-boxexpand
sizetitlemedium
typeinfo
Output

This The function returns a

Status
subtletrue
titletext
representing the date-time value at t, in a certain time zone and a certain language.




UI Text Box
sizemedium
typetipinfo

Variant where you can additionally define a custom date time pattern (see documentation)This function is useful in the Action Update Field to represent as a text the result of a time expression.


Code Block
languagebash
titleSyntax
linenumberstrue
 dateTimeToString(number ttimestamp, timeZone time_zonedateTimePattern, language) #Output: Text


UI Expand
Examples
titleExample


Parser expressionDescription


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


This 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).
numberOfDaysdateTimePattern

Status
subtletrue
titlenumbertext

A Java date time pattern (see documentation).

language

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

Status
subtletrue
titletimezonelanguage

The time zone language used for the calculationconversion. 

Expand
titleLearn more about timezones
Excerpt Include
Dates, times and time zonesDates, times and time zones
nopaneltrue



-textbox
ui
-
typetip

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. 

ui-expand
titleOutput

The This function returns a

Status
subtletrue
titletext




UI Text Box
sizemedium
typeinfo

The function returns a

Status
subtletrue
titletext
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.

UI Text Box
typenote

This function is useful in Action Update Field to represent as a text the result of a time expressionVariant where you can specify a custom format according to the date time pattern and additionally a time zone (see documentation).


Code Block
languagebash
titleSyntax
linenumberstrue
 dateTimeToString(numbertimestamp, tdateTimePattern, string date_time_pattern timeZone, language) #Output: Text


UI Expand
titleExampleExamples


Parser expressionDescription


Code Block
dateTimeToString(2011-03-25 11:30,
languagebash
linenumberstrue
dateTimeToString(0, "yyyy.MM.dd 'at' HH:mm:ss", GMT, USER_LANG)


This example returns:

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:

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
function will return
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 (see documentation).
timeZone

Status
subtletrue
titletimezone

The time zone used for the calculation. 

language

Status
subtletrue
titlelanguage

The language used for the conversion. 



UI Expand
titleOutput

This function returns a

Status
subtletrue
titletext



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

: "2011.03.25 at 11:30:00"