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.

Between Dates in Visual Query Builder w Easy Set Up For Dynamic Data

atlas6890
5 - Atom

Hi,

 

I am pretty new to Alteryx. 

 

I am using a dynamic input that is linked to a database. The database has a ton of data in it and I would like to use the Visual Query Builder's Criteria to limit the data that is run. I would like to limit the criteria based on a field called TradeDate, which is a date-based field. I would like to be able to use the criteria on this field to be the first and last day of a month. This is my first question, as I am not sure how to do this. 

 

My second question relates to the first in that I would like to set up the query and modify the the SQL Query to replace the first and last date in the criteria in a way that would allow a user to run the app for any one month period of time. I planned to do this by using the date selection with an action tool that feeds into a text input that feeds again into the dynamic input and use the modify SQL query to replace the string of text in the criteria with the newly input date; however, again, I am not sure how to do this with both the first and second date in the criteria.

 

Any help would be appreciated.

1 REPLY 1
mbarone
16 - Nebula
16 - Nebula

Your first step will be to set up a workflow that does what you want it to for a specific start/end date.  The Tool Mastery Index is a good place to review how to use the Dynamic Input tool first.

Labels
Top Solution Authors