Status
Tech review

Style guide




Short description

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

Output




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


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




Parameters used in this function

ParameterInput (data type)Description
timestamp

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

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

The time zone used for the calculation. 


<parameter>

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. 



The function returns a




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


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



Parser expressionDescription


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


The function will return a : "2011.03.25 at 11:30:00"




Parameters used in this function

ParameterInput (data type)Description
timestamp

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

<language><language>


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. 



The function returns a




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


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



Parser expressionDescription


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


The function will return a : "1970.01.01 at 00:00:00"


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


The function will return a : "1969.12.31 at 17:00:00"



Parameters used in this function

ParameterInput (data type)Description
timestamp

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

timeZone

The time zone used for the calculation. 


<language><language>


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. 



The function returns a