Dynamically changing the start time and time of SQL query

Question

My question is When I give a SQL statement. Select * from MoneyTransactions where recordtime>='2021-05-01 00:00:00' and recordtime<='2021-05-07 23:59:59'. I want to dynamically change the recordtime recordtime>='2021-05-08 00:00:00' and recordtime<='2021-05-14 23:59:59' and so on. How can I do this in Alteryx?

Divyaranga · Answer

Sure I will provide the required inputs.

mceleavey · Answer

@Divyaranga ,

you will need to provide your input tool with the SQL script so I can build that for you.

M.

Divyaranga · Answer

Many Thanks. Can I get a workflow for my SQL query using the dynamic input tool. Thanks in Advance