Date format and filtering date

Question

Hi All,

I need to filter data based on a invoice date. I need to see all transactions for specific month let's say Jan-22 in a data where I have invoices for multiple periods. My date format is 12/01/2023. I was trying to filter as below but getting error that date format is incorrect. How can I fix this?

Invoice date >= '2022-01-01'

AND

Invoice date <= '2022-01-31'

Many thanks for your help,

Aga

aga123 · Answer

Thank you all, I managed to fix the issue.

ShankerV · Answer

hi @aga123

Please find the expected output.

Many thanks

Shanker V

Date format and filtering date.yxmd

ShankerV · Answer

Hi @aga123

Please change the Invoice date to Alteryx date format YYYY-MM-DD and then use the filter.

Use datetime tool to achieve this.