Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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