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

Alteryx Designer Desktop Discussions

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

Dynamic Date Range using Interface Design

AnilKangude
5 - Atom

Hi Community,

 

I have a workflow which outputs columns along with Date Field. I want to create a report which is generated on Date Range selected using Dynamic Date Filter in Interface Design.

So I want to basically filter data based on this Date column i.e. From and To date selected in interface designer.

 

Example:

As per the attached workflow, I want to select Range on Paid Date to filter data based on selection of From and To Dates.

 

Could you please help if this is possible. Thanks !!

 

 

6 REPLIES 6
grazitti_sapna
17 - Castor

Hi @AnilKangude , can you please attach the source file as I am not able to access it.

 

grazitti_sapna_0-1597035144805.png

 

Thanks.

 

Sapna Gupta
AnilKangude
5 - Atom

Please find attached Sample Data.

grazitti_sapna
17 - Castor

Hi @AnilKangude , I hope this is what you are looking for?

 

grazitti_sapna_0-1597038787388.png

 

Alternate Solution:

 

grazitti_sapna_1-1597037865099.png

 

 

grazitti_sapna_0-1597037835288.png

 

You can try any of the methods mentioned above and please mark this post as solution if this is what you are looking for.

 

Thanks.

Sapna Gupta
AnilKangude
5 - Atom

Hi Sapna,

 

I want to use Date Interface Tool to Select Date Range instead of Drop Down since the actual data will be huge and pulled from database. 

 

Can we do it with Date Tool ?

 

 

Thanks in Advance !!

grazitti_sapna
17 - Castor

Hi @AnilKangude ,

There you go.

grazitti_sapna_1-1597039206789.png

 

grazitti_sapna_0-1597039169149.png

 

Thanks.

 

Sapna Gupta
AnilKangude
5 - Atom

Thank You So Much for your help !!

Labels
Top Solution Authors