---
title: Alteryx 2023.1 - new 'between' formula
description: Amongst the new features of Alteryx 2023.1 is a new formula function called ‘between’. It helps you find values that fall within a specific range and can be used anywhere...
---

[DDBM Blog ](https://www.ddbm.com/blog)

# [Alteryx 2023.1 - new 'between' formula](https://www.ddbm.com/blog/2023/05/26/alteryx-2023-1-new-between-formula)

 Geschreven door [Arjan Loogman](https://www.ddbm.com/blog/author/arjan-loogman) | 25 May, 2023

Amongst the new features of [Alteryx](https://www.theinformationlab.nl/technologie/alteryx/) 2023.1 is a new formula function called ‘between’. It helps you find values that fall within a specific range and can be used anywhere there is an expression editor – think of the different Formula Tools, the Filter Tool, etc.

The formula function is written as follows: between([column name], upper bound, lower bound). The result of the formula is a boolean value: True or False. This value can be used for logic in your workflow – think of filtering records or conditionally applying other formulas to your data. I think this is an improvement over the old method, where you would have to write ‘is-higher-than-or-equal-to and is-lower-than-or-equal-to’ in one expression:

*working with ‘between’ versus ‘ye olde method’*

Keep in mind that both the upper and lower bound will be included in the selected range:

*upper bound and lower bound included* *‘between’ also works with decimal numbers *

Just to be clear, ‘between’ is not available in a Filter Tool in simple mode, it can only be found in the expression editor of the custom filter:

*no between…* *…between!*

Is this new ‘between’ function an absolute life saver? Probably not. Will it speed up your expression writing, and thus your data prepping? I think it most certainly will!

*Thank you for reading this blog. Also check out our other [blogs](https://www.theinformationlab.nl/blogs/) page to view more blogs on [Tableau](https://www.theinformationlab.nl/technologie/tableau/), [Alteryx](https://www.theinformationlab.nl/technologie/alteryx/), and [Snowflake](https://www.theinformationlab.nl/technologie/snowflake/).*

***[Work together](https://www.theinformationlab.nl/en/ons-team/) ** with one of our consultants and maximize the effects of your data. *

*[**Contact us**](https://www.theinformationlab.nl/en/contact/) , and we’ll help you right away.*

*blog banner: original photo by [Roman Mager](https://unsplash.com/@roman_lazygeek?utm_source=unsplash&utm_medium=referral&utm_content=creditCopyText) on [Unsplash](https://unsplash.com/photos/5mZ_M06Fc9g?utm_source=unsplash&utm_medium=referral&utm_content=creditCopyText)*

[Volledig bericht weergeven](https://www.ddbm.com/blog/2023/05/26/alteryx-2023-1-new-between-formula)

```json
{
  "@context" : "http://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Arjan Loogman"
  },
  "dateModified" : "2026-02-11T10:29:10.237Z",
  "datePublished" : "2023-05-25T22:00:00Z",
  "headline" : "Alteryx 2023.1 - new 'between' formula",
  "image" : {
    "@type" : "ImageObject",
    "height" : 678,
    "url" : "https://www.ddbm.com/hubfs/Imported_Blog_Media/roman-mager-5mZ_M06Fc9g-unsplash-1-1.png",
    "width" : 1920
  },
  "mainEntityOfPage" : "https://www.ddbm.com/blog/2023/05/26/alteryx-2023-1-new-between-formula",
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "height" : 60,
      "url" : "/hs/hsstatic/content_shared_assets/static-1.4092/img/default-amp-logo.png",
      "width" : 60
    },
    "name" : "DDBM Blog"
  }
}
```