We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Pull Data for Date Range

dngnc7
7 - Meteor

I am trying to configure a date range between two years. Each month, the <= date is updated. Below I have a screen shot of what I currently use but does anyone know of a different way to accomplish this? Thanks!

 

 
 

Capture.PNG

4 REPLIES 4
ChrisTX
16 - Nebula
16 - Nebula

Use a left parenthesis before [DATE] and a right parenthesis before OR, repeat for each occurrence of [Date]

 

Are you asking how to convert to something like a batch macro or an app, and make the Date value a parameter?

 

Chris

dngnc7
7 - Meteor

Ultimately, my intention is to load the workflow into Alteryx server with users selecting the dates in a drop down. I am just unsure of how to do it with a range between two years. 

ChrisTX
16 - Nebula
16 - Nebula

See attached App and Example Debug created by running the App.

 

You'll need to learn about creating Apps: https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Creating%2...

And how to test and Debug the App using the Interface Designer.

 

Check out the Videos and Weekly Challenges under Learn > Academy

 

Chris

dngnc7
7 - Meteor

Thanks Chris! worked perfectly

Labels
Top Solution Authors