field between
This block is part of the query group and was last modified in core v10.4.28.
Connection Type
This block connects from a query type block. Make sure to connect this block to the appropriate left-hand side connection.
Parent Requirements
This block requires specific parent elements: query_bool_range_date_field, query_first_defined, query_aggregation. Ensure this block is placed within the appropriate parent context.
field between v10.4.28 In pins 2
- >= required
dateThe date thats greater or equal to the given field
- <= required
dateThe date thats lower or equal to the given field
Out pins 1
- query
query
higher |
lower |
lowerequal |
higherequal |
A typical wiring for field between: set to: end of day feeds the date_gte pin; set to: start of day feeds the date_lte pin; the query out pin feeds date.

Commonly used with
In production blueprints, this block is most often wired together with:
- set to: end of day: feeds into this block. Returns the end of the day for the given date.
- set to: start of day: feeds into this block. Returns the start of the day for the given date.
- date: this block feeds into it. do range checks on date fields.
Version history
Introduced in v10.4.28.
Back to
query Return to the main group to view all sub-groups Back to range date Return to the group to view all blocks within this group
