Parse Date from String

[cpet13]

I have a column with strings, similar to the following - the_previous_week2024-01-18T20-39-19+00-00 and the_previous_week_2024-01-18T20-39-19+00-00. From both of these types of strings, I am trying to extract the date (2024-01-18). Can I use regex to do this, or is there another way I could do that? I am trying to do it in a way so that, if a different format of string is added such as the_previous_week_x2024-01-18T20-39-19+00-00, it will still work. Any thoughts on how I could do that?

[MilindG · Accepted solution]

@cpet13 

[cpet13]

That is great, thank you!