How can I push my Workflow Configuration Start and End Date into Dynamic Input Tool?

Hi everyone,

I'm using the Workflow Configuration screen to Input a Start and End Date when running my workflow. Those Start and End Dates are referenced in various formulas. However, I wanted to pass those Start and End Dates dynamically into my ODBC connection in a SQL statement for a WHERE date >= Start Date and WHERE date <= End Date based off the user's input of the Workflow Config section. I see a Dynamic Input tool would be useful here, but how would I reference those Workflow Config start and end dates there? Any help is appreciated!

Datasets

Developer

Developer Tools

Input

Common Use Cases

Best Practices

Apps

Batch Macro

Dynamic Processing

Preparation

Optimization

Data Investigation

Database Connection

Accepted answers

BrandonB

I would suggest maybe something like is shown below. You can use a Text Input tool with some placeholder value followed by a formula tool that creates the start date and end date columns using the constants that you have defined. Then you follow that with a Dynamic Input tool which updates the WHERE clause.

dynamic input.png

All comments

BrandonB

dynamic input.png

hydrogurl01

Hi @BrandonB ,

Would you be able to show me what that text input would look like? Also would this replace the user workflow configuration I currently have for start and end dates? I'm referring to those fields in my formula tools so would I have to replace those?

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335