Dates
How to use filter operators for facets containing values of date datatype.
Explorer provides powerful date filtering capabilities to help you find data within specific time periods. You can filter date columns using a variety of standard operators and date formats.
Available Date Operators
When filtering date columns, you can use these operators:
equals - Matches exact dates
before - Shows dates before a specified date
after - Shows dates after a specified date
between - Shows dates within a specified range
empty - Shows only empty date values
not empty - Shows only non-empty date values
Using Date Filters
Date filtering is straightforward but flexible. Simply:
Click the search input in a date column filter
Choose your preferred operator
Select or enter the date(s)
Click "Apply" to activate the filter
Date Ranges
The "between" operator lets you filter for a specific time period. This is particularly useful when you want to analyze data from a certain timeframe or study changes over time.
All dates use UTC time zone for consistency across different regions.
Last updated
Was this helpful?