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/
Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels