Pull Data for Date Range

[dngnc7]

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!

[dngnc7]

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!

[ChrisTX]

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]

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 · Accepted solution]

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]

Thanks Chris! worked perfectly