This function converts a text with a certain format into a timestamp.

stringToDate(text, timeZone) #Output: Number
Parser ExpressionDescription
%{stringToDate(%{issue.cf10002}, RUN_AS_LOCAL)}

This example will convert a text containing date information into a valid timestamp. The configured run-as user's timezone is used for conversion.



Parameters used in this function

ParameterInput (data type)Description
text

The parameter must contain a text in a specific format. Usually this value is retrieved from a field.

Valid input string formats are: 

  • yyyy/MM/dd HH:mm
  • yyyy-MM-dd HH:mm
  • yyyy/MM/dd, yyyy-MM-dd,

Also formats defined in moment are valid.

timeZone

The time zone used for the calculation. 

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. 

This function returns a


Variant where you can manually define the date-time pattern. Read more about date-time patterns.

stringToDate(text, dateTimePattern ) #Output: Number
Parser expressionDescription
%{stringToDate("2020.03.25 11:30:00", "yyyy.MM.dd HH:mm:ss")}

This example returns a timestamp 1583062200000 representing the given date-time value.


Parameters used in this function

ParameterInput (data type)Description
text

The parameter must contain a text in a specific format. Usually this value is retrieved from a field.
dateTimePattern

Manually defined date-time pattern. Read more about date-time patterns.

This function returns a

Short description

Converts a text into a date.

Output