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

[DavidSkaife]

Hi @KamenRider 

Here you go, simple formula in the filter tool does the trick:

[DataNath · Accepted solution]

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:

[Emmanuel_G]

@KamenRider 

In attachement the way of doing that.

[KamenRider]

Thanks @DavidSkaife , @Emmanuel_G , @DataNath  for your ideas.

[spina]

Anyone know how to filter the Datetimetoday but with a specific time? 

[KamenRider]

Hi Spina,

Good day,

Can you please cite an example, provide us screenshots and/or share your workflow so anyone here can help you more?

Thanks,

Kamen