Hi there,
I attempted to extract data like attached files using a date filter, but I get an error. Please show me how to solve this problem.
Sakiko
Hi @Sakiko
No worries! That was quick to resolve then. You can't convert string (text) fields to date by just changing the type in the select tool. Alteryx isn't able to tell what the date parts are. Rather, you need to add a datetime tool that converts your date into the proper format. Now it's in date format and you can do your filter.
Hope that helps!
Kat
Can you attach or post some sample data?
Can you please package your data into the workflow. You can go to options -> export workflow. Make sure that the data file is checked.
Your date filter straight up doesn't look wrong - perhaps you could also share a screen shot of your error?
