dateTimeToString()

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

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

Syntax

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

Examples

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).
`<numberOfDays>`	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`	TIMEZONE	The time zone used for the calculation.
`<parameter>`	DATA TYPE	Parameter description.

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.

Output

The function returns a TEXT

The function returns a 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.

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

Syntax

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

Example

Parser expression	Description
dateTimeToString(2011-03-25 11:30, "yyyy.MM.dd 'at' HH:mm:ss", USER_LANG)	The function will return a TEXT : "2011.03.25 at 11:30:00"

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).
`<date_time_pattern>`	TEXT	Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aliquam fermentum vestibulum est. Cras rhoncus. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Sed quis tortor. Donec non ipsum. Mauris condimentum, odio nec porta tristique, ante neque malesuada massa, in dignissim eros velit at tellus. Donec et risus in ligula eleifend consectetur. Donec volutpat eleifend augue. Integer gravida sodales leo. Nunc vehicula neque ac erat. Vivamus non nisl. Fusce ac magna. Suspendisse euismod libero eget mauris.
`<language>`	`<language>`	Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aliquam fermentum vestibulum est. Cras rhoncus. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Sed quis tortor. Donec non ipsum. Mauris condimentum, odio nec porta tristique, ante neque malesuada massa, in dignissim eros velit at tellus. Donec et risus in ligula eleifend consectetur. Donec volutpat eleifend augue. Integer gravida sodales leo. Nunc vehicula neque ac erat. Vivamus non nisl. Fusce ac magna. Suspendisse euismod libero eget mauris.

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.

Output

The function returns a TEXT

The function returns a 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.

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

Syntax

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

Examples

Parser expression	Description
dateTimeToString(0, "yyyy.MM.dd 'at' HH:mm:ss", GMT, USER_LANG)	The function will return a TEXT: "1970.01.01 at 00:00:00"
dateTimeToString(0, "yyyy.MM.dd 'at' HH:mm:ss", MST, USER_LANG)	The function will return a TEXT: "1969.12.31 at 17:00:00"

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).
`<date_time_pattern>`	TEXT	Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aliquam fermentum vestibulum est. Cras rhoncus. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Sed quis tortor. Donec non ipsum. Mauris condimentum, odio nec porta tristique, ante neque malesuada massa, in dignissim eros velit at tellus. Donec et risus in ligula eleifend consectetur. Donec volutpat eleifend augue. Integer gravida sodales leo. Nunc vehicula neque ac erat. Vivamus non nisl. Fusce ac magna. Suspendisse euismod libero eget mauris.
`timeZone`	TIMEZONE	The time zone used for the calculation.
`<language>`	`<language>`	Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aliquam fermentum vestibulum est. Cras rhoncus. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Sed quis tortor. Donec non ipsum. Mauris condimentum, odio nec porta tristique, ante neque malesuada massa, in dignissim eros velit at tellus. Donec et risus in ligula eleifend consectetur. Donec volutpat eleifend augue. Integer gravida sodales leo. Nunc vehicula neque ac erat. Vivamus non nisl. Fusce ac magna. Suspendisse euismod libero eget mauris.

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.

Output

The function returns a TEXT

Content

Space Tools

Parameters used in this function

Parameters used in this function

Parameters used in this function