How to filter out based on custom date

[Dittau]

Hello,

I am using the filter tool and want to be abke to filter out certain info if a date is today or in the future. Whats is the formula i would use for this?

ex: any row with a cell under the date column of 4/10/2022 and in the future gets filtered out

[binuacs]

@Dittau use the condition [Date] >= DateTimeToday()

Where the [Date] is your date field in the input file

[Dittau]

That didn’t work for me can you type it out like if you had the below ex and you wanted to filter out items 4/10/2022 and in the future

column 1      Date

a.                   4/10/2023

b.                   4/09/2023

c.                    6/11/2025

does the date format have to be in alteryx date format yyyy-mm-dd for this formula to work?

[binuacs · Accepted solution]

@Dittau First you need to convert the Date field into Alteryx Date Format

[nagakavyasri · Accepted solution]

@Dittau Date parse the given date and add filter