Skip to main content
Checks whether a value lies within a given range. The function is inclusive, so it includes the beginning and end values of the range. Category: logical Syntax: 
Between([value_column], lower_bound, upper_bound)
Returns: BooleanColumn Context Filtering: ✓ Yes

​
Parameters

NameTypeRequiredDescription
valuenumber|date|datetime|column✓ YesThe input value or column containing the values to check.
lower boundnumber|date|datetime✓ YesThe lower bound of the range to check.
upper boundnumber|date|datetime✓ YesThe upper bound of the range to check.
Allowed Column Types: INT, FLOAT, DECIMAL, DATE, DATETIME

​
Validation

  • Minimum parameters: 3
  • Maximum parameters: 3

​
Examples

Between([Invoice Date], MakeDate(2015, 1, 1), MakeDate(2020, 1, 1))
Returns True if a date value is between January 1, 2015 and January 1, 2020. 
Between([Sale Date], DateAdd("day", -7, Now()), Now())
Returns True if a sale happened in the last 7 days.
  • In - Check if value matches specific values
  • If - Apply logic based on conditions
Last modified on March 13, 2026