community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Need help with creating app for dates

Asteroid

Hi

Trying to create an app for selecting the dates,in below example have items and created date, want the data to be pulled from the created date by selecting the start date and end date .

 

ItemCreated Date
A6/24/2018
B5/25/2018
C4/26/2018
D3/27/2018
E3/28/2018
F2/29/2018
G1/30/2018
H2/1/2018
I2/2/2018

 

Example :if i want to know the items created between 2/1/2018 and 4/26/2018 i need to enter in app giving start date as 2/1/2018 and end date as 4/26/2018.

 

the result should be 

 

ItemCreated Date
H2/1/2018
I2/2/2018
D3/27/2018
E3/28/2018
C4/26/2018

 

screen.PNG

 

Alteryx Certified Partner
Alteryx Certified Partner

This should be relatively straight forward; however the image you provided us wont be enough to help us debug.

 

Could you share an image of the entire workflow and also how both 'actions' are configured. Alternatively attaching the workflow with some sample data is just as good!

 

Ben

Asteroid

Hi Ben,

 

can you please attach the workflow i could not see it.

 

Thanks in Advance.

 

Regards

 

Pulsar
Pulsar

I think maybe a macro would be better.  Something like the attached.  Save it to your macro folder (should be C:\Program Files\Alteryx\bin\RuntimeData\Macros).


Then it will be on your macro palette.  Drop it on the canvas.  Connect a file TO it, and select the date field you want to compare, and then select your start/end date.  The output of the macro will be your filtered results.  

 

I think this is what you're looking for.  Let me know.

Labels