Page History

Versions Compared

Key

This line was added.
This line was removed.
Formatting was changed.

UI Text Box

size	medium
type	info

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

Code Block

language	bash
title	Syntax
linenumbers	true

stringToDate(text, timeZone) #Output: Number

UI Expand

title	Examples

Parser Expression

Description

Code Block

language	bash
linenumbers	true

stringToDate(%{issue.cf10002}, LOCAL)

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

UI Expand

title	Additional information

Parameters used in this function

Parameter Input (data type) Description

text

Status


subtle	true
title	text

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

UI Text Box

type	note

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

Status


subtle	true
title	timezone

The time zone used for the calculation.

UI Text Box

type	tip

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.

UI Expand

title	Output

This function returns a

Status

subtle	true
title	number

UI Text Box

size	medium
type	info

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

Code Block

language	bash
title	Syntax
linenumbers	true

stringToDate(text, dateTimePattern ) #Output: Number

UI Expand

title	Examples

Parser expression

Description

Code Block

language	bash
linenumbers	true

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.

UI Expand

title	Additional information

Parameters used in this function

Parameter Input (data type) Description

text

Status


subtle	true
title	text

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

dateTimePattern

Status


subtle	true
title	text

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

UI Expand

title	Output

This function returns a

Status

subtle	true
title	Number

UI Text Box

size	medium
type	info

Variant where you can additionally define a language and a country.

Code Block

language	bash
title	Syntax
linenumbers	true

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

UI Expand

title	Examples

Parser expression

Description

Code Block

language	bash
linenumbers	true

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.

UI Expand

title	Additional information

Parameters used in this function

Parameter Input (data type) Description

text

Status


subtle	true
title	text

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

dateTimePattern

Status


subtle	true
title	text

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

language

Status


subtle	true
title	text

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

country

Status


subtle	true
title	text

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

UI Expand

title	Output

This function returns a

Status

subtle	true
title	Number

UI Text Box

type	tip

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

Use cases and examples

Page properties report

firstcolumn	Use case
headings	JWT feature, Workflow function, Field type, Automated action, Parser functions
cql	label = "parser_func_stringtodate" and space = currentSpace()

Page properties

hidden	true

Status

Tech review

Status

colour	Green
title	done

Style guide

Status

colour	Green
title	done

Status

title	todo

Status

colour	Yellow
title	Ready for review

Status

colour	Green
title	done

Status

colour	Red
title	flagged

Page properties

hidden	true

Short description

Converts a text into a date.

Output

Status

subtle	true
title	number

Available since

Status

subtle	true
colour	Blue
title	2.2.29

Label

Content

Space Tools

Versions Compared

Old Version 14

New Version 15

Key

Parameters used in this function

Use cases and examples