Inconsistent date strings

[Bunbunrachel]

Spoiler

Hi, 

I am trying to parse the following strings into dates but some do not have “Year” available. I tried passing them using regex_match and regex_replace function but formulae do not currently pick them up.

Raw date:

5:45PMAEST-13-Dec

5:30AMAEST-27/12

2023-01-2310:29:00

3:00AMCDT17thMay

2:00AMAEST18thMay(thesisthetime)

Appreciate any help on this!

[Bunbunrachel]

My 2nd qn is: My current REGEX formulaes does not  seem to pick up the first data value even though condition is included. Any idea why?

Raw data:

10:37amAEST30/05/2023 - not picked up

10:45amCDT-30/05/2023 - pick up

Appreciate any help on the above qn!

[binuacs]

@Bunbunrachel one way of doing this