Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Using Date interface with filter is not working

eduardomarchesin
8 - Asteroid

Hi team,

 

I'm facing an issue when I try to filter some registers using the date interface function. 

When I run the workflow show me a correct result. For instance datetime_out >= 2021-04-01

eduardomarchesi_0-1620329155865.pngeduardomarchesi_1-1620329200851.png

But when I run it as an analytic app, the result keep the same. For instance, I changed the date to 2021-01-01.

eduardomarchesi_2-1620329274403.pngeduardomarchesi_3-1620329356480.png

 

How can I solve it?

Please find attached the alteryx workflow.

Rgds

Eduardo

 

2 REPLIES 2
AngelosPachis
16 - Nebula

Hey @eduardomarchesin ,

 

The issue is in the action tool, which is the tool that applies whatever selection you make in the app interface to the actual workflow.

 

Currently, you have not selected which value should get replaced, so if you click on the action tool, you will notice that it is not configured

 

AngelosPachis_0-1620330689993.png

 

The value you want to replace is whatever comes after the >= in your expression, the operand, so if you select it as shown below

 

AngelosPachis_1-1620330736022.png

 

and save the app, that should do it.

 

eduardomarchesin
8 - Asteroid

Hi @AngelosPachis 

 

Perfect, it worked.

Thank you very much

Eduardo

Labels