Does Alteryx have a BETWEEN function or something similar?

[mkeiffer]

Hi there,

Does Alteryx Designer have a something similar to a BETWEEN function?  For example, if I wanted to find records with a transaction amount between 1,000 and 5,000 dollars, I could write a formula as follows:

BETWEEN(Transaction_Amount, 1000, 5000) 

And all of the records that had a transaction amount between and including 1,000 and 5,000 would be displayed.

Is there a similar function in Alteryx Designer, or must this expression be written the "long" way:

Transaction_Amount >= 1000 AND Transaction_Amount <= 5000

Thanks in advance for your help!

Mike

[ArtApa · Accepted solution]

@mkeiffer - 2023.1 is here and it includes BETWEEN 😀: https://community.alteryx.com/t5/Analytics/2023-1-Enterprise-Ready-Cloud-Friendly/ba-p/1116702?utm_s... 

[mkeiffer]

@ArtApa Thanks so much for the heads up.  I just downloaded the new version today.  Thanks again!

[NicoleJ · Accepted solution]

We have just released this new Between function today in our 23.1 release! Hope you can check it out! 😁

[mkeiffer]

@NicoleJ Thank you so much! I just downloaded the latest version today. Thank you again for the heads up on this!