Datetime Filter Operators

Supported Operators

Jetstack's datetime-family filters support:

  • null
  • not_null
  • equal
  • equal_advanced
  • not_equal
  • not_equal_advanced
  • less_than
  • less_than_advanced
  • greater_than
  • greater_than_advanced
  • between
  • preset

Operator Semantics

Direct Value Operators

  • equal
  • not_equal
  • less_than
  • greater_than
  • between

Use these when the date boundary is explicit.

Advanced Operators

  • equal_advanced
  • not_equal_advanced
  • less_than_advanced
  • greater_than_advanced

These operators first evaluate an expression and then normalize it as a datetime boundary. Use them when the comparison value should be computed from runtime context.

Presets

preset uses built-in platform ranges such as:

  • today
  • tomorrow
  • yesterday
  • this week
  • last 7 days
  • this month
  • last 30 days
  • previous month
  • previous 3 months
  • this year
  • future and past variants

Why This Family Deserves Special Care

Date filtering often looks simple in the UI but carries subtle meaning:

  • inclusive vs exclusive boundaries
  • current day vs full timestamp
  • dynamic comparison values
  • locale and timezone expectations

The datetime family exists to make those rules explicit.

Example

Use less_than_advanced when a field should be filtered by "before the date stored in another field" rather than before a fixed date entered by the user.

Best Practices

  • use presets whenever the business concept matches a known preset
  • use advanced operators when the boundary depends on another runtime value
  • be explicit about whether a condition is "before", "after", or "within range"
Previous← IntroductionNextFiles →