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. 



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



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)



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



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