Extract a date from summary string and apply to Due date

Thomas G_dii0pc

Hi community,

I am trying to extract a date from summary and apply that date to the Due date field. I have a similar challenge as mentioned in this post but my date appears in the middle of the string and not at the end, hence making the right() function unusable here.

I thought I could use the match() function but have not succeeded.

Here is my summary: Create New User Bill Gates (NYC) on 10/30/2021 is approved

I would like to extract 10/30/2021 from this string.

I have unsuccessfully tried putting the following in an edit issue fields component: {{issue.summary.match("(\d+\W\d*\W\d*)").toDate}}

 

Any tips much appreciated!

 

Best regards
Thomas

Manon Soubies-Camy

Hi @Thomas G,

The following automation rule should meet your needs:

Here are the details of the Create variable action:

You can copy the smart value below:

{{issue.summary.match("(\d{1,4}([.\-/])\d{1,2}([.\-/])\d{1,4})")}}

Here are the details of the Edit issue action:

You can copy the smart value below:

{{newDueDate.toDate("MM/dd/yyyy")}}

Let me know if this works on your side too!

- Manon