Date Interface Tool

Question

Hi everyone, I´m starting to practice with Alteryx Designer, and I need some support related with the Interface Tool.

Do you know if it´s possible to select the Date Interface Tool to update some date at the table query connection?

Or just will be necessary to load all the data, and after that put the correct filters, using for example Formula Tool?

Thank you!

apathetichell · Answer

you mean like have the date/time tool update  a time in a WHERE clause? yes.

have you action tool configured to update value. have it highlight the SQL query component of the Connect-INDB/Input Data in the action tool... Set it to replace a specific string where the specific string is a base date like '2021-10-21' (so 2021-10-21 is the specific string to replace)