Page History

Versions Compared

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 description

Returns any given date in text form.

Output

Status


subtle	true
title	text

UI Text Box

size	medium
type	info

Returns any given date in text form.

UI Text Box

type	tip

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

Code Block

language	bash
title	Syntax
linenumbers	true

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

UI Expand

title	Examples

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

language

Status


subtle	true
title	Language

Parameter description.

UI Expand

title	Output

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

Code Block

language	bash
title	Syntax
linenumbers	true

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

UI Expand

title	Example

Parser expression

Description

Code Block

language	bash
linenumbers	true

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

The function will return a

Status

subtle	true
title	text

: "2011.03.25 at 11:30: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).

Status


subtle	true
title	data type

Parameter description.

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

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

Code Block

language	bash
title	Syntax
linenumbers	true

 dateTimeToString(number t, string date_time_pattern , 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

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

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

Status


subtle	true
title	data type

Parameter description.

timeZone

Status


subtle	true
title	timezone

The time zone used for the calculation.

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

The function returns a

Status

subtle	true
title	text

Content

Space Tools

Versions Compared

Old Version 18

New Version 19

Key

Parameters used in this function

Parameters used in this function

Parameters used in this function