Parse Date From File Path

[DataPirate26]

Hi all,

Need help in Parsing out the Date in Date Format "YYYY-MM-DD" from the Full Path. It needs to be dynamic as the path can change. 

Look into the Attached Sample below and please help out with a solution

[binuacs]

@DataPirate26 One way of doing this, this formula also checks whether the date has "th" or "nd" or "st" based on that it applies the regex formula

[gawa]

@DataPirate26 

Regex + Formula would suffice. Please adjust regex if it does not make sense to your real data.

[Dev73]

@DataPirate26  one more solution to it , I have tried to keep it simple and understandable 😊