Get started

Use case library

JWT expression editor

JWT expression parser functions

JWT remote actions

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 14 Next »

This function returns any given date in text form, where you can specify a custom format according to the date time pattern (see documentation) and additionally a time zone.

Syntax
 dateTimeToString(timestamp, dateTimePattern, timeZone, language) #Output: Text
Examples
Parser expressionDescription
%{dateTimeToString({issue.created}, "dddd, MMMM Do YYYY, h:mm:ss a", "MST", "en")}

This example will return:

The issue's creation date in a readable way using the Moutain Time ZoneWednesday e.g.  Friday, March 6th 2020, 2:29:21 am

%{dateTimeToString(0, "dddd, MMMM Do YYYY, h:mm:ss a", "Pacific/Auckland", RUN_AS_LANG)}

This example will return:

Thursday, January 1st 1970, 12:00:00 pm

Additional information

Parameters used in this function

ParameterInput (data type)Description
timestamp

NUMBER

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

TEXT

A date time pattern in text form according to the moment patterns.
timeZone

TEXT

The time zone used for the conversion. 

language

TEXT

The language used for the conversion. 

Output

This function returns a TEXT

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