Start Free Trial

Alteryx Designer Desktop Discussions

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

In Database formula

Cferrer6
8 - Asteroid

hello, 

 

i am trying to pull 3 months worth of data from snowflake using  indatabase tools. the format is 2023-05-01. Are suggestions on formulas or filters that can do that ?

1 REPLY 1
caltang
17 - Castor
17 - Castor

If you're using IN-DB, you can write SQL statements to pull your data out as you would normally do on a DB. 

 

You can use the Filter In-DB tool and cast the Date value, then use the dates >= 2023-02-01 AND dates < 2023-05-01.

 

 

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
Labels
Top Solution Authors