Hi,
I have a very simple question!
How to I filter all the Date values from a column with Sting values included. My Date format is yyyy-mm-dd.
Thanks
Hi @rajputakansha ,
I have created 2 examples in how to filter dates. One way is by simply changing the data type, the other is by using a datetimediff function.
If this solves your issue please mark the answer as correct, if not let me know!
Hope this helps.
Best,
Fernando V.
Hi @rajputakansha,
Is this what you're trying to achieve?
Input:
Output:
If so i would use a Regex_Match function inside a filter tool REGEX_Match([Column], '\d{4}-\d{1,2}-\d{1,2}')
If this solves your issue please mark the answer as correct, if not let me know! I've attached my workbook for you to download if needed.
Regards,
Jonathan
Hi @Jonathan-Sherman ,
Can you please explain what we did here in the Regex formula?
Thank you!
Hi @fmvizcaino ,
Thanks for your response.
Can you please explain how changing the data type can filter the values.
Example;
COLUMN
abc
2019-12-12
bcd
2019-02-12
rfg
2018-01-10
This is my column from which I want to filer out the dates.
@rajputakansha the reason I did not go down the same route as @fmvizcaino is because changing the data type would remove the (non date) rows from the data stream. Using a filter against a regex_match would still keep these "non date" rows available to be used later in the workflow if so desired.
