Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Using Filters

traceystone
8 - Asteroid

Hello,

 

Seeking help with a custom filter. I need to filter out everything in the [Asset Status] column that is = "Retired" and has a [Scheduled Retirement date] < "01/01/2020". I have attached the workflow and a snapshot of what the data looks like in those 2 columns. What I have doesn't seem to be working.

11 REPLIES 11
traceystone
8 - Asteroid

I attached the spreadsheet, workflow, the formula, and the errors I am getting.

MatthewBr
Alteryx Alumni (Retired)

you provided only one of the 2 spreadsheets ?

 

MatthewBr_0-1631557435946.png

 

Labels
Top Solution Authors