Editing SQL Query Dynamically with a cell reference from Excel

[nickrosen28]

Hi everyone,

I have a SQL query that inputs data that I need for a workflow I have running on a bi-weekly cadence. This query or small variations of the query appear 7-10 times in the workflow for various reasons, making it a pain/prone to error if I manually edit each time i run the WF.

The only thing that needs to be changed is the date for the query where I specify "WHERE date column BETWEEN '2024-11-01' AND '2024-11-30'"

Is there a way to do this to have all the query's change date range from referencing an excel cell?

I have watched YT videos, checked online/community site and feel like I am close, but not getting results.

Any help is appreciated!

Thanks

[alexnajm · Accepted solution]

The Dynamic Input is your friend here! The Modify SQL query would be useful:  Dynamic Input Tool

[alexnajm]

More resources: Tool Mastery | Dynamic Input entrée de données entrée dynamique eingabedaten dynamische eingabe