Tom Azernour avatar
Written by Tom Azernour
Updated over a week ago

Type: Function

Function: BETWEEN

Syntax: BETWEEN(number|datetime, start, end)

Description: Returns true if the provided value is between (>= and <=) the start and end values.

Sample usage:

  • BETWEEN(lines_changed, 100, 1000) returns true if lines_change = 500, returns false if lines_change = 1200

  • BETWEEN(created_at, BEGINNING_OF_YEAR, END_OF_YEAR) => returns true if the created_at field value is within the current year.

Did this answer your question?