Filtering the Current Date

KamenRider

HI guys,

I would like to ask for your ideas on how I can  filter out or exclude the current date (like today which is 10-04-2022) every time I run the workflow. I have tried a lot of way like using the formula tool (IF [DATE] = DATETIMETODAY() THEN "00/00/000" ELSE [DATE] ENDIF" then follow a filter tool but it is not working. 

For below example as attached, i would like date to return to 10-03-2022 and 10-02-2022 since it is not the current date

Please advise.

Kamen

Filtering current date.xlsx

DataNath

Hey @KamenRider, you could use a Filter tool with the following expression - Alteryx recognises dates in YYYY-MM-DD format and so the DateTimeParse() function is just used to get your incoming dates into this format. After that, it just checks whether or not they're the same as today's date by using the DateTimeToday() function. You're interested in what comes out of the top (True) anchor i.e. dates that aren't equal to today:

DateTimeParse([Date],'%m-%d-%Y') != DateTimeToday()

As you can see, today's date has been excluded and filtered out through the bottom (False) anchor:

Exclude today's date.yxmd