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}, 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.

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 a text in a specific format. Usually this value is retrieved from a field.

Note

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 defined in moment are valid.

timeZone

Status


subtle	true
title	text

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 11:30:00", "yyyy.MM.dd HH:mm:ss")}

This example returns a timestamp 1583062200000 representing the given 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 a text 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

Image AddedUse 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

Short description

Converts a text into a date.

Output

Status

subtle	true
title	number

Content

Space Tools

Versions Compared

Old Version 12

New Version 13

Key

Image AddedUse cases and examples