Get started

Use case library

JWT expression editor

JWT expression parser functions

JWT remote actions

Cloud migration hub

Additional product info

Versions Compared

Old Version 1

changes.mady.by.user Julian Riedinger

Saved on

compared with

New Version Current

changes.mady.by.user Julian Riedinger

Saved on

Key

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

Page properties
hiddentrue
Status
Tech review

Status
colourGreen
titledone

Style guide

Status
colourGreen
titledone

Status
titletodo
Status
colourYellow
titleReady for review
Status
colourGreen
titledone
Status
colourRed
titleflagged

Page properties
hiddentrue
Short description

Converts a text into a date.

Output

Status
subtletrue
titlenumber

Available since

Status
subtletrue
colourBlue
title2.2.29

UI Text Box
sizemedium
typeinfo

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


Code Block
languagebash
titleSyntax
linenumberstrue
stringToDate(text, timeZone) #Output: Number


UI Expand
titleExamples


Parser ExpressionDescription


Code Block
languagebash
linenumberstrue
%{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
titleAdditional information

Parameters used in this function

ParameterInput (data type)Description
text

Status
subtletrue
titletext

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

Note
typenote

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


timeZone

Status
subtletrue
titletimezonetext

The time zone used for the calculation. 


UI Text Box
typetip

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
titleOutput

This function returns a

Status
subtletrue
titlenumber





UI Text Box
sizemedium
typeinfo

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


Code Block
languagebash
titleSyntax
linenumberstrue
stringToDate(text, dateTimePattern ) #Output: Number


UI Expand
titleExamples


Parser expressionDescription


Code Block
languagebash
linenumberstrue
%{stringToDate("2020.03.25 at 11:30:00", "yyyy.MM.dd 'at' HH:mm:ss")}


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




UI Expand
titleAdditional information

Parameters used in this function

ParameterInput (data type)Description
text

Status
subtletrue
titletext

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

Status
subtletrue
titletext

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



UI Expand
titleOutput

This function returns a

Status
subtletrue
titleNumber



Image AddedUse cases and examples

Page properties report
firstcolumnUse case
headingsJWT feature, Workflow function, Field type, Automated action, Parser functions
cqllabel = "parser_func_stringtodate" and space = currentSpace()


Page properties
hiddentrue


UI Text Box
sizemedium
typeinfo

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

Code Block
languagebash
titleSyntax
linenumberstrue
stringToDate(text, dateTimePattern, language, country ) #Output: Number
UI Expand
titleExamples
Parser expressionDescription
Code Block
languagebash
linenumberstrue
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
titleAdditional information

Parameters used in this function

ParameterInput (data type)Descriptiontext StatussubtletruetitletextThe parameter must contain data in a specific format. Usually this value is retrieved from a field.dateTimePattern Statussubtletruetitletext

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

language StatussubtletruetitletextDefine the language for the conversion. Valid input parameters can be found here: ISO 639-2country StatussubtletruetitletextDefine the country for the conversion. Valid input parameters can be found here: ISO 3166 alpha-2 UI Expand
titleOutput
This function returns a
Short description

Converts a text into a date.

Output

Status
subtletrue
title

Number UI Text Box
typetip

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

number