Extract date in MMM dd format from issue description and set custom field

[Dutchie]

Hi community!

I'm trying to extract a date in the format MMM dd from an issue description and set that as a value in the due date. The regex I have for this is:

[A-z]{3},\s([A-z]{3}\s\d\d?)\s{3}[A-z]{3},\s[A-z]{3}\s\d\d?

This extracts the right date from the description, but I've been unsuccessful in converting this to a format that I can set in a date field.

This is what I've add as a log action which returns the expected date {{issue.Description.match("[A-z]{3},\s([A-z]{3}\s\d\d?)\s{3}[A-z]{3},\s[A-z]{3}\s\d\d?")}} but whenever I've tried to format it, the log entries go blank.

[Dutchie · Accepted solution]

Realized that the reason this wasn't working for me is that you can't match and convert at once. I needed to create a variable for the the date where I added the year and then converted it to a date format.

Create variable varStartDate - {{issue.Description.match("[A-z]{3},\s([A-z]{3}\s\d\d?)\s{3}[A-z]{3},\s[A-z]{3}\s\d\d?")}}, {{now().format("yyyy")}}

Convert variable to date {{varStartDate.toDate("MMM d, yyyy")}}

[Beth Soprano]

I was looking for help after experiencing issues related to cryptocurrency and online investment scams. The service responded promptly, explained the recovery process clearly, and maintained communication throughout. While every case is different and MHR recovery can be guaranteed, I appreciated their professionalism and responsiveness.

If you're seeking assistance after becoming the victim of an online scam, be sure to do your own research and contact https : / / mightyhackarrecovery . com

[Vikrant Yadav]

Hi @Dutchie Welcome to Atlassian Community!

The duedate must be of the format "yyyy-MM-dd", then only automation set duedate field value

[Dutchie]

Thanks @Vikrant Yadav