Re-Running a Workflow with a Variable Date

[raychase]

Hello,

I have a basic workflow that is querying a SQL database in an input tool, and then outputting (appending) that data to a SQLite file.  The query filters on a 2 week period, because the dataset is very large, and will get killed if I extend the time frame.  My first query ran from 01-01-2018 until 01-15-2018.  My next run would be 01-16-2018 until 01-30-2018.  And so on and so forth...

Whenever the workflow has finished running, I would like to be able to automatically add 14 days to my date range and have the workflow run again.  Can anyone provide some insight into how this would be done?  Ideally, it would run sequentially until the SQLite file contains all data from 01-01-2018 until present.

[Claje · Accepted solution]

Hi,

I think you can do this really easily by using the Dynamic Input tool.  If you move your SQL query to this tool, you can then input a set number of two week periods using pre-steps.

I've attached a really quick example workflow for you as well.

Hope this helps!

[raychase]

Thanks for the quick reply!  I will give this a shot tomorrow at work.

[raychase]

I have used your workflow as a template, and it seems to be working perfectly.  Thank you so much!