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

Creating a Date Range

ll98
9 - Comet

I have the following WF -- Where Im able to pull a range of dates ( Batch GL Date) but I just want to capture a range of it..

 

Lets said I just need to capture the data from  Jan 1, 2021 thru April 30, 2021.  I'll also will like to turn it into an app -- where the end user can input the dates as well

 

Attached is the WF

13 REPLIES 13
ll98
9 - Comet

@apathetichell  I simplify the data a little better 

apathetichell
19 - Altair

Sorry,  I'm still not 100% clear on what you're looking for. I went back to my version of the workflow because there are still some data errors on select based conversion on that one.  This one now sums up a beginning balance and ending balance at a filtered date (12/31/2020) and one to the present. It renames both sums  and then creates one set of records with all four fields.

 

Is this close?

ll98
9 - Comet

@apathetichell   -- Thanks -- But I want to turn it into an App -- I would want the user to input both dates --   will this still work.... 

apathetichell
19 - Altair

Kind of like this?

 

 

Labels
Top Solution Authors