Automation Export to Excel

@bastak Get rid of the SQL iterator. Its only purpose was to give you a variable. Now you have the "Create Variable" and "Variable Prompt" actions to do that instead. Set it up to look just like my last set of screen shots (with your own SQL in the export dataset action, of course)

Also: note that I have selected "Environment Variable", not "Literal"

"Literal" would be used if you wanted to specify the date value (like 06-10-2021) in the export dataset action itself, rather than take it from a variable.