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
    date

    The date thats greater or equal to the given field

  • <= required
    date

    The 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.

Studio canvas example for the field between block: typical wiring for field between.

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