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
18 - Pollux

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
18 - Pollux

Kind of like this?

 

 

Labels