How to Extract Date from a Comment & Apply to a Custom Field?

Question

Hello all.

I am trying to extract a date (US format) using Jira automation from a string inside of a comment.

A couple of examples of comments I need to be able to parse out the date from are below.

1.) WO Reassignment - WO #WO01708082 has been reassigned to xyz with a due date of 3/4/2023.

2.)  Pending WO Auto-Dispatched (Parts) - All pre-ordered parts for this work order have been delivered by the carrier, and the work order is being dispatched. New ETA: 3/4/2023 8:00:00 PM

I have gotten this far in my automation below, but I am stuck on how to pull the variable out of the string to use later in the automation.

Any ideas? Any help is greatly appreciated.

David Di Benedetto · Answer

Probably worth mentioning that my "Tech ETA" field is not an open string. It is "Date/Time Picker"

David Di Benedetto · Answer

It looks like these two work as per my testing, but I need to have something that can grab dates in either format (mm/dd/yyyy & m/d/yyyy)

(\d{1}(\/|-)\d{1}(\/|-)\d{2,4}) - pulls dates with 1 in m/d (ex. 3/4/2023)
(\d{2}(\/|-)\d{2}(\/|-)\d{2,4}) - pulls dates with 2 numbers in m/d (ex. 03/04/2023)