Page History

Versions Compared

Old Version 16

changes.mady.by.user Iheb Kharab

Saved on Mar 17, 2020

compared with

New Version Current

changes.mady.by.user Iheb Kharab

Saved on Jan 04, 2022

Key

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

Page properties

hidden	true

Status

Tech review

Status

title	todo

Style guide

Status

title	todo

Status

title	todo

Status

colour	Yellow
title	Ready for review

Status

colour	Green
title	done

Status

colour	Red
title	flagged

Page properties

hidden	true

Short descriptionReturns a Statussubtletruetitletext representing the date-time value at t, in a certain time zone and a certain language.Output Statussubtletruetitletext UI Text Box

size	medium
type	info

The This function returns a

Status

subtle	true
title	text

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

UI Text Box

type	tip

This function is useful in the Action Update Field to represent as a text the result of a time expression.the full timestamp (date and time) of any given date in text form.

Code Block

language	bash
title	Syntax
linenumbers	true

dateTimeToString(number ttimestamp, timeZone time_zone, language) #Output: Text

UI Expand

title	Examples

Parser Expression

Description

Code Block

language	bash
linenumbers	true

dateTimeToString({issue.created}, LOCAL, USER_LANG)

This example could return:

18/May/20 7:52 AM

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

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

<numberOfDays>

Status

subtle	true
title	number

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


subtle	true
title	timezone

The time zone used for the calculationconversion.

Expand

title	Learn more about timezones

Excerpt Include

Dates, times and time zones Dates, times and time zones

nopanel true

language

<parameter>

Status


subtle	true
title	data type

Parameter description.

UI Text Box

type	tip

Language

The language used for the conversion.

UI Expand

title	Output

The This function returns a

Status

subtle	true
title	text

UI Text Box

size	medium
type	info

The function returns a

Status

subtle	true
title	text

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

type	note

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

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

Code Block

language	bash
title	Syntax
linenumbers	true

 dateTimeToString(number ttimestamp, string date_time_pattern dateTimePattern, language) #Output: Text

UI Expand

title	Example

Parser expression

Description

Code Block

language	bash
linenumbers	true

dateTimeToString(2011-03-25 11:30{issue.created}, "yyyy.MM.dd 'at' HH:mm:ss", USER_LANG)

This example could return:

2020.05.18 at 07:52:02The function will return a

Status

subtle	true
title	text

: "2011.03.25 at 11:30:00"

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

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

<parameter>dateTimePattern

Status


subtle	true
title	data type

Parameter description.

text

A Java date time pattern (see documentation).

language<parameter>

Status


subtle	true
title	data type

Parameter description.

UI Text Box

type	tip

language

The language used for the conversion.

UI Expand

title	Output

The This function returns a

Status

subtle	true
title	text

UI Text Box

size	medium
type	info

The function returns a

Status

subtle	true
title	text

representing the date-time value at t with a certain custom format defined by date_time_pattern text parameter, in a certain time_zone using a certain language for months, days of the week, etc.

UI Text Box

type	note

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

language	bash
title	Syntax
linenumbers	true

 dateTimeToString(number ttimestamp, string date_time_pattern dateTimePattern, timeZone time_zone, language) #Output: Text

UI Expand

title	Examples

Parser expression

Description

Code Block

language	bash
linenumbers	true

dateTimeToString(0, "yyyy.MM.dd 'at' HH:mm:ss", GMT, USER_LANG)

The function will return a

Status

subtle	true
title	text

This example returns:

1970.01.01 at 00:00:00

Code Block

language	bash
linenumbers	true

dateTimeToString(0, "yyyy.MM.dd 'at' HH:mm:ss", MST, USER_LANG)

The function will return a

Status

subtle	true
title	text

: "

This example returns:

1969.12.31 at 17:00:00

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

<parameter>dateTimePattern

Status


subtle	true
title	data type	text

A Java date time pattern (see documentation)Parameter description.

timeZone

Status


subtle	true
title	timezone

The time zone used for the calculation.

language

Status


subtle	true
title	language

The language used for the conversion.

ui-expand

title

Learn more about timezones

Excerpt Include

Dates, times and time zones Dates, times and time zones

nopanel true

<parameter>

Status

subtle true

title data type

Parameter description.

UI Text Box

type	tip

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

title	Output

	Output

This function returns a

Status

subtle	true
title	text

Image AddedUse cases and examples

Page properties report

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

Page properties

hidden	true
id	1

Parser function cloud	dateTimeToString()
Map
Notes

Page properties

hidden	true

Status

Tech review

Status

colour	Green
title	done

Style guide

Status

colour	Green
title	done

Status

title	todo

Status

colour	Yellow
title	Ready for review

Status

colour	Green
title	done

Status

colour	Red
title	flagged

text

Page properties

hidden	true

Short description

Returns the timestamp of any given date in text form.

Output

Status


subtle	true
title	text

Available since

Status

subtle	true
colour	Blue
title	2.4.0

Label

Status


colour	Red
title	staff pick

The function returns a

Status

subtle

true

title

Content

Space Tools

Versions Compared

Old Version 16

New Version Current

Key

Image AddedUse cases and examples