Changing Date using interface Tool

[CsmithData31]

Hello! 

I am a new user to Alteryx. I am currently working on a project that needs  me to use a interface tool like the date tool to change my SQL date. 

Here is a Example of the simple query I have. 

Select * 

from database

where database.deliverydate > = '20210812'

Currently Looking for a way to use the interface tool to update only the query date '20210812'. I am currently using the the Update Value with formula = Replace "deliverydate", '20210812' but  I am unable to get anything to change. 

Thank you for your time.

[binu_acs]

@CsmithData31 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Update-date-variable-in-where-clause-c...

[mceleavey · Accepted solution]

Hi @CsmithData31 ,

You just need to update the specific date value in the selection string:

Example workflow attached.

I hope this helps,

M.

[CsmithData31]

This Worked Thank you!!!

[mceleavey]