Get and use date as due date

[Geoffrey Jonkers]

Hello,

We're wondering if someone could help us further with the following challenge :)
We're trying to capture a date in the description field (Effective date: 2023-08-28) and use this as the due date. Sadly we're unable to figure out how this works.

We're starting with the Advanced compare condition. 
{{issue.description}}
Contains
regex .*Effective date: ([0-9]{4}-[0-9]{2}-[0-9]{2}).*

And this will not work, of course we tried many options here but are still unlucky.
Who could help us further In this case :)

[Mark Segall · Accepted solution]

Hi @Geoffrey Jonkers 

I just tried this in my test environment

{{issue.description}}
Contains Regex
(\b\d{4}-\d{2}-\d{2}\b)

Your Due Date would be populated like this:

{{issue.description.match("(\b\d{4}-\d{2}-\d{2}\b)")}}

[Geoffrey Jonkers]

Hi @Mark Segall 
Could you tell me what's wrong in here?

[Mark Segall]

There's a specific condition in the dropdown for Contains Regex.  Use that and remove "regex" from the second value field.

[Geoffrey Jonkers]

Ahhh gotcha. I'll play arround with that one :) Thanks!

[Geoffrey Jonkers]

One more, question maybe.
Is there an option to include the Effective date part?

[Mark Segall]

Yes - You should be able to just update the regex to this:

(Effective date: \b\d{4}-\d{2}-\d{2}\b)

[Geoffrey Jonkers]

It works if I make the Effective date not bold. In our case it's bold.
Tried single and double * but seems not to work.

nest step for us is changing the layout. from yyyy-mm-dd to -> mm-dd-yyyy (for DueDate)
 We have this;

Follow with
a new variable which is 

{{extractedDate.subStringAfterLast("-")}}-{{extractedDate.subStringBeforeLast("-").subStringAfter("-")}}-{{extractedDate.subStringBefore("-")}}"

[Geoffrey Jonkers]

Before I forget. Many kudos! Really happy with your help in this case :)

[Jack Brickey]

Hi @Geoffrey Jonkers ,

not sure if this helps you or not but I leveraged the following article in the past for a similar need - How-to-parse-the-description-field-for-values-to-put-into-other-Jira-custom-fields .