1. Getting Started
  2. Date Filters

Getting Started

Date Filters

Supported Filter Conditions

The following filter conditions are supported:

  • equals: Checks if the date equals the specified value.
  • not_equals: Checks if the date does not equal the specified value.
  • gt: Checks if the date is greater than the specified value.
  • lt: Checks if the date is less than the specified value.
  • gte: Checks if the date is greater than or equal to the specified value.
  • lte: Checks if the date is less than or equal to the specified value.
  • bwi: Checks if the date is between two specified values (inclusive).
  • bwe: Checks if the date is between two specified values (exclusive).
  • in: Checks if the date is within a list of specified values.
  • not_in: Checks if the date is not within a list of specified values.

Usage

The date filter should be provided as a string in the following format:

        <condition>:<date1>,<date2>,...

      

Examples

  1. Equals

            equals:2024-12-16T14:10:53Z
    
          
  2. Not Equals

            not_equals:2024-12-16T14:10:53Z
    
          
  3. Greater Than

            gt:2024-12-16T14:10:53Z
    
          
  4. Less Than

            lt:2024-12-16T14:10:53Z
    
          
  5. Greater Than or Equal To

            gte:2024-12-16T14:10:53Z
    
          
  6. Less Than or Equal To

            lte:2024-12-16T14:10:53Z
    
          
  7. Between Inclusive

            bwi:2024-12-16T14:10:53Z,2024-12-17T14:10:53Z
    
          
  8. Between Exclusive

            bwe:2024-12-16T14:10:53Z,2024-12-17T14:10:53Z
    
          
  9. In List

            in:2024-12-16T14:10:53Z,2024-12-17T14:10:53Z
    
          
  10. Not In List

            not_in:2024-12-16T14:10:53Z,2024-12-17T14:10:53Z
    
          

Validation

  • The dates must be in a valid ISO string format.
  • For bwi and bwe conditions, exactly two dates must be provided.
  • The first date must be less than the second date for bwi and bwe conditions.
  • Duplicate dates in in and not_in conditions will be filtered out.