You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 17 Next »

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
Additional information

Parameters used in this function

ParameterInput (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.

Syntax
 dateTimeToString(number t, string date_time_pattern , language) #Output: Text
Example
Parser expressionDescription
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

ParameterInput (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).
<parameter>

DATA TYPE

Parameter description.

<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, in a certain time_zone using a certain language for months, days of the week, etc.

Syntax
 dateTimeToString(number t, string date_time_pattern , timeZone time_zone, language) #Output: Text
Examples
Parser expressionDescription
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

ParameterInput (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).
<parameter>

DATA TYPE

Parameter description.
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