nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Converting string to date object with Automation

Hieu Phan_k5b40m

I am currently utilizing Automaton for Jira LITE to handle incoming issues from emails. In the issue description, there is a date in a form of a string which I extract with a regex using match(). I can convert the string into a date object using .toDate. However, the converted object is not the correct date.

For example, one of the descriptions has a date of "September 3, 2019". I used .toDate("MMMM d, YYYY") to convert it to a date object with the correct format. I then format that date further to .format("d/MMM/yy"). It should spit out 3/Sep/19. The actual output is 30/Dec/18. When put it into a different format like yyyy-mm-dd, it spits out 2018-00-30. I've also tried changing the month in the description in July, same result. My guess is that my string format may cause Automation to read it incorrectly.

Could this be related to how I've extracted the string via regex from the description? Should I try formatting the extracted string in a certain way so Jira/Automation can read it correctly?

Accepted answers

Nick Menere

Hi Hieu,

I think we may need to break this down step by step. Use a log action or add comment with the following:

Parse: {{description.match("regex")}}
Date: {{description.match("regex").toDate}}
Date Format: {{description.match("regex").toDate.as("d/MMM/yy"}}

That should hopefully show us where it is breaking.

Cheers,

Nick

All comments

Nick Menere

Hi Hieu,

I think we may need to break this down step by step. Use a log action or add comment with the following:

Parse: {{description.match("regex")}}
Date: {{description.match("regex").toDate}}
Date Format: {{description.match("regex").toDate.as("d/MMM/yy"}}

That should hopefully show us where it is breaking.

Cheers,

Nick

Hieu Phan_k5b40m

Hey Nick,

Thanks for replying.

Here is my output with the regex pulling "July 3, 2019" -

Parse: July 3, 2019
Date: 
Date Format:

I believe .toDate requires you to match the format of the string which is why I used .toDate("MMMM d, yyyy") to get an output for that function. Else, it comes up empty as you can see above.

Hieu Phan_k5b40m

I figured out what I did incorrectly -

Seems like there is a difference between YYYY and yyyy when formatting the year for turning a string into a date object.

.toDate("MMMM d, yyyy") was what I needed to use.

Jeret Shuck_hfty3t

@Nick Menere

I'm effectively trying to do the same as Hieu here. However, when doing so, I'm only getting the following back:

Parse: June

Date:

Date Format:

Here's what I have in my automation:

Parse: {{issue.description.match("(January|February|March|April|May|June|July|August|September|October|December) (\d{2}), (\d{4})$")}}

Date: {{issue.description.match("(January|February|March|April|May|June|July|August|September|October|December) (\d{2}), (\d{4})$").ToDate}}

Date Format: {{issue.description.match("(January|February|March|April|May|June|July|August|September|October|December) (\d{2}), (\d{4})$").toDate.as("yyyy/MM/dd")}}

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

addon-com.codebarrel.addons.automation

jira-server

automation

date