stringToDate() | Decadis App Help Center

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

Bash

stringToDate(text, timeZone) #Output: Number

Examples

Parser Expression	Description
Bash `stringToDate(%{issue.cf10002}, LOCAL)`	This example will convert a text containing date information into a valid timestamp.

Parser Expression

Description

Bash

stringToDate(%{issue.cf10002}, LOCAL)

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

Additional information

Parameters used in this function

Parameter	Input (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.

Bash

stringToDate(text, dateTimePattern ) #Output: Number

Examples

Parser expression	Description
Bash `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.

Parser expression

Description

Bash

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

Parameter

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

Bash

stringToDate(text, dateTimePattern, language, country ) #Output: Number

Examples

Parser expression	Description
Bash `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

Parameter	Input (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