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

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

This example will convert a text containing date information into a valid timestamp.



Additional information

Parameters used in this function

ParameterInput (data type)Description
text

TEXT

The parameter must contain data 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 relative to the current time like in JQL queries: "w" (weeks), "d" (days), "h" (hours) or "m" (minutes), or formats defined at system property jira.date.time.picker.java.format are valid.

timeZone

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. 

Output

This function returns a NUMBER


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

Syntax
stringToDate(text, dateTimePattern ) #Output: Number
Examples
Parser expressionDescription
stringToDate("2020.03.25 at 11:30:00", "yyyy.MM.dd 'at' HH:mm:ss")

This example returns a timestamp representing a date-time value.


Additional information

Parameters used in this function

ParameterInput (data type)Description
text

TEXT

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

TEXT

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

Output
This function returns a NUMBER


Variant where you can additionally define a language and a country

Syntax
stringToDate(text, dateTimePattern, language, country ) #Output: Number
Examples
Parser expressionDescription
stringToDate("Dec 7, 2020 2:10:25 AM PST", "MMM d, yyyy h:mm:ss a z", "eng", "US")

This example returns a timestamp based on the parameters provided.

Additional information

Parameters used in this function

ParameterInput (data type)Description
text

TEXT

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

TEXT

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

language

TEXT

Define the language for the conversion. Valid input parameters can be found here: ISO 639-2
country

TEXT

Define the country for the conversion. Valid input parameters can be found here: ISO 3166 alpha-2
Output

This function returns a NUMBER

This function is mostly used when you want to write the output into a Jira date-time picker.

If you want to convert a date into a text you might want to have a look at the function dateToString().