In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Changing Date using interface Tool

CsmithData31
7 - Meteor

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.

4 REPLIES 4
mceleavey
17 - Castor
17 - Castor

Hi @CsmithData31 ,

 

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

 

mceleavey_0-1639498815819.png

 

mceleavey_1-1639498851678.png

 

Example workflow attached.

I hope this helps,

 

M.

 



Bulien

CsmithData31
7 - Meteor

This Worked Thank you!!!

mceleavey
17 - Castor
17 - Castor

michael-scott-wink.gif

 



Bulien

Labels
Top Solution Authors