This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
If you want to dynamically change these values based on datetimenow(), for example, or by other logic, then you can put your input tool with the SQL script in a macro and feed these values in as control parameters which can then overwrite the value in the SQL script in an action tool.
Alternatively, if you would like the user to input these values then you can build an analytic app using the interface tools to update the values in the SQL script from a datetime picker.