Date format and filtering date

[aga123]

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

[FinnCharlton]

Hi @aga123 ,

Your date is likely in a string field, you will need to convert it to a date first. Try this:

[Felipe_Ribeir0]

Hi @aga123 

Try this formula inside of your filter tool:

datetimeparse([Invoice date], '%d/%m/%Y') >= '2022-01-01'

AND

datetimeparse([Invoice date], '%d/%m/%Y')  <= '2022-01-31'

[ShankerV]

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.

[ShankerV]

hi @aga123 

Please find the expected output.

Many thanks

Shanker V

[aga123]

Thank you all, I managed to fix the issue.