How would I filter specific format data

[Bansi08]

Hi there -- I have column in the table as per below. I want to filter out only date formatted data and rest all should be eliminated. I am beginner level alteryx user. Please guide me on this. 

Column Name
0:00:00
Alpha
Beta
[null]
total
SOP
As of 03/31/2023
Date
Total Value
2021-03-25
2022-06-30
2022-07-31
2021-09-15
2021-03-25
2022-06-30
2022-07-31
2021-09-15
2021-03-25
2022-06-30
2022-07-31
2021-09-15
2021-03-25
2022-06-30
2022-07-31

Output data

Column Name
2021-03-25
2022-06-30
2022-07-31
2021-09-15
2021-03-25
2022-06-30
2022-07-31
2021-09-15
2021-03-25
2022-06-30
2022-07-31
2021-09-15
2021-03-25
2022-06-30
2022-07-31

[Prometheus · Accepted solution]

You could use a Filter tool with the expression: REGEX_Match([Column Name], '^\d{4}\-\d{2}\-\d{2}') to only allow records to pass that match the pattern specified in the regular expression. Take a look at www.regex101.com for help with regular expressions.

 

[grazitti_sapna]

Hi @Bansi08 Parse tool - Date Time solve it in easy way!
Kindly Check. Hope it works for you 
Thanks

[Bansi08]

Thanks both for your solution. 

[Rob48]

Was looking for help on this topic and just so happened that I needed filtering for dates in the same format.  I copy/pasted your formula, worked like a charm, thank you!

I have other data that comes with different date formatting I need to check.  I played around with your original formula but my RegEx skills are very weak and I couldn't convert it to a useful filter.  How can I adjust the formula to filter for the following date formats:

28 May, 2025

28May'25

for reference the original was:

REGEX_Match([Data as of], '^\d{4}\-\d{2}\-\d{2}')