Does Alteryx support using BETWEEN function

[Mary456]

Is it possible to execute a query using BETWEEN function in Alteryx

For example using : Between Date '2012-01-01' and Date '2014-01-01'

[IraWatt · Accepted solution]

Hey @Mary456,

Interesting question, the filter tool does support a configuration called range which is equivalent to between (shown below):

Though the actually code implementation of this is just using the <>= operators:

[Date1] >= "2022-09-26" AND
[Date1] <= "2022-09-26"

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com 

[CarliE · Accepted solution]

@Mary456 

You will have to do [Date]>= '2012-01-01' and [Date] <='2014-01-01'

[DataNath]

As the others have mentioned, you currently have to handle this with a bit of a long-winded approach, though it looks like after some back and forth this should hopefully be getting added to Designer soon!

https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Add-quot-BETWEEN-quot-as-an-operator-functio...

[Mary456]

Thank you !

[apathetichell]

Are you querying from Snowflake? If so - the answer is yes as part of Snowflake SQL.