Date Filter error

[Sakiko]

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

[DavidP]

Can you attach or post some sample data?

[kat]

Hi @Sakiko

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?

[Sakiko]

Thank you for your reply.

Here is the workflow including data.

[kat]

@Sakiko - I think you forgot to include the attachment

[Sakiko]

Oops! sotty!  I upload it again!

[kat · Accepted solution]

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

[Sakiko]

@kat

I was able to solve it with your workflow!
I am very grateful because I was in time for the deadline.

Sakiko

[kat]

@Sakiko, that's great to hear!