Page History

Versions Compared

Key

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

UI Text Box

size	medium
type	info

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

Code Block

language	bash
title	Syntax
linenumbers	true

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

UI Expand

title	Examples

Parser Expression

Description

Code Block

language	bash
linenumbers	true

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

This example could return:

18/May/20, 7:52 am

UI Expand

title	Additional information

Parameters used in this function

Parameter Input (data type) Description

timestamp

Status

subtle	true
title	number

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

timeZone

Status


subtle	true
title	timezone

The time zone used for the conversion.

language

Status


subtle	true
title	Language

The language used for the conversion.

UI Expand

title	Output

This function returns a

Status

subtle	true
title	text

UI Text Box

size	medium
type	info

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

Code Block

language	bash
title	Syntax
linenumbers	true

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

UI Expand

title	Example

Parser expression

Description

Code Block

language	bash
linenumbers	true

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

This example could return:

2020.05.18 at 07:52:02

UI Expand

title	Additional information

Parameters used in this function

Parameter Input (data type) Description

timestamp

Status

subtle	true
title	number

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

dateTimePattern

Status


subtle	true
title	text

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

language

Status


subtle	true
title	language

The language used for the conversion.

UI Expand

title	Output

This function returns a

Status

subtle	true
title	text

UI Text Box

size	medium
type	info

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

Code Block

language	bash
title	Syntax
linenumbers	true

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

UI Expand

title	Examples

Parser expression

Description

Code Block

language	bash
linenumbers	true

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

Code Block

language	bash
linenumbers	true

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

UI Expand

title	Additional information

Parameters used in this function

Parameter Input (data type) Description

timestamp

Status

subtle	true
title	number

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

dateTimePattern

Status


subtle	true
title	text

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

timeZone

Status


subtle	true
title	text

The time zone used for the conversion.

language

Status


subtle	true
title	text

The language used for the conversion.

UI Expand

title	Output

This function returns a

Status

subtle	true
title	text

UI Text Box

type	tip

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

Image AddedUse cases and examples

Page properties report

firstcolumn	Use case
headings	JWT feature, Workflow function, Parser functions, Label
cql	label = "parser_func_datetimetostring" and space = currentSpace()

Page properties

hidden	true

Short description

Returns the timestamp of any given date in text form.

Output

Status


subtle	true
title	text

Page properties

hidden	true

Status

Tech review

Status

colour	Red
title	flagged

2nd example needs rework

Style guide

Status

colour	Yellow
title	Ready for review

Status

title	todo

Status

colour	Yellow
title	Ready for review

Status

colour	Green
title	done

Status

colour	Red
title	flagged

Content

Space Tools

Versions Compared

Old Version 16

New Version 17

Key

Image AddedUse cases and examples