dateTimeToString() | Decadis App Help Center

Timestamp text with timezone

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

Bash

dateTimeToString(timestamp, timeZone, language) #Output: Text

Examples

Parser Expression	Description
Bash `%{dateTimeToString({issue.created}, RUN_AS_LOCAL, RUN_AS_LANG)}`	This example could return: 18/May/20, 7:52 am

Parser Expression

Description

Bash

%{dateTimeToString({issue.created}, RUN_AS_LOCAL, RUN_AS_LANG)}

This example could return:

18/May/20, 7:52 am

Additional information

Parameters used in this function

Parameter	Input (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).
`timeZone`	timezone	The time zone used for the conversion.
`language`	Language	The language used for the conversion.

Output

This function returns a text

Timestamp text with pattern

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

Bash

 dateTimeToString(timestamp, dateTimePattern, language) #Output: Text

Examples

Parser expression	Description
Bash `%{dateTimeToString({issue.created}, "YYYY.MM.DD [at] HH:mm:ss", "en_GB")}`	This example could return: 2020.05.18 at 07:52:02

Parser expression

Description

Bash

%{dateTimeToString({issue.created}, "YYYY.MM.DD [at] HH:mm:ss", "en_GB")}

This example could return:

2020.05.18 at 07:52:02

Additional information

Parameters used in this function

Parameter	Input (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).
`dateTimePattern`	text	A date time pattern in text form according to the moment patterns.
`language`	language	The language used for the conversion.

Output

This function returns a text

Timestamp text with pattern and timezone

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

Bash

 dateTimeToString(timestamp, dateTimePattern, timeZone, language) #Output: Text

Examples

Parser expression	Description
Bash `%{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 Zone e.g. Friday, March 6th 2020, 2:29:21 am
Bash `%{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

Parser expression

Description

Bash

%{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 Zone e.g. Friday, March 6th 2020, 2:29:21 am

Bash

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

Parameter	Input (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.

(books) Use cases and examples

Use case	Workflow function	Parser functions
Set a date field to the current date	Update fields	dateTimeToString()
Set a date field to a future date	Update fields	dateTimeToString()
Record an auditable timestamp of a Compliance Approval	Update fields	dateTimeToString()
Add three days skipping weekends automatically to a Date Picker	Update fields