Date Filtering

Date columns have specialized filtering options. This page covers relative time windows, time modes, and the smart autocomplete feature.

Date vs Datetime columns

The system distinguishes between:

Date columns: Store only the date (no time)
Datetime columns: Store both date and time

When filtering datetime columns, you can use the Force Date toggle to treat them as date-only, ignoring the time portion.

Date operators

Operator	Description
On	Matches the specified date or datetime
Not On	Excludes the specified date or datetime
Before	Matches dates earlier than the value
After	Matches dates later than the value
Between	Matches dates within a relative time window
Is Blank	Matches null/empty date values
Is Not Blank	Matches non-null date values

Time modes

For On, Before, and After operators, you can choose from three time modes. Access them by clicking the gear icon next to the value input.

Current time with offset

Compare against the current time, optionally shifted.

Configuration:

Days: Number of days to offset
Hours: 0-23
Minutes: 0-59
Direction: Past or Future

Examples:

0 days, 0 hours, 0 minutes = “now” (or “today” for date-only)
1 day into the past = “yesterday”
7 days into the past = “7 days ago”
2 hours, 30 minutes into the future = “2.5 hours from now”

Useful for rolling time windows that update automatically.

Static time

Select a fixed date using a calendar picker. The filter always compares against this exact date, no matter when the dashboard is viewed.

Relative time

Uses the same picker as the Between operator. When using relative time with On/Before/After, specify whether you want the Beginning or End of the period:

Beginning: Start of the period (e.g., 12:00 AM on the first day)
End: End of the period (e.g., 11:59 PM on the last day)

The Between operator

Between creates rolling time windows that update automatically. Unlike static date ranges, it uses relative periods defined by time units and offsets.

Time units

Unit	Description
Day	Calendar days
Week	Calendar weeks (configurable start day)
Month	Calendar months
Quarter	Calendar quarters (Q1-Q4)
Year	Calendar years

Start and end boundaries

Each Between filter needs two boundaries:

Start boundary: When the window begins
End boundary: When the window ends

Each boundary is defined by:

A time unit (day, week, month, quarter, year)
An offset (positive for future, negative for past, zero for current)

Smart autocomplete

The start and end inputs have smart autocomplete. Type natural language and the system suggests matches.

Keywords:

today — Current day
yesterday — Previous day
tomorrow — Next day
last — Previous period (e.g., “last week”, “last month”)
this — Current period (e.g., “this quarter”, “this year”)

Numbers:

Type any number for offset options (e.g., type 7 for “7 days ago”, “7 weeks ago”, etc.)

Examples:

Type last month for the previous calendar month
Type 3 for options like “3 days ago”, “Start of the month 3 months ago”
Type week for week-related options

Hour selection

For precise boundaries, click the clock icon to set a specific hour:

Start hour: When the window begins (default: 12:00 AM)
End hour: When the window ends (default: 11:59 PM)

Useful when your business day doesn’t align with midnight-to-midnight.

Week start configuration

Click the gear icon to set which day starts the week (Sunday through Saturday). This affects all week-based calculations.

Examples preview

Click the info icon to see example date ranges based on your current configuration. The preview shows what dates would match if evaluated:

Now
In 1 day
In 1 week

Helpful for verifying your filter is set up correctly.

Common Between configurations

Goal	Start	End
Today	Start of this day	End of this day
Yesterday	Start of day 1 day ago	End of day 1 day ago
This week	Start of this week	End of this week
Last week	Start of week 1 week ago	End of week 1 week ago
This month	Start of this month	End of this month
Last 30 days	Start of day 30 days ago	End of this day
This quarter	Start of this quarter	End of this quarter
Year to date	Start of this year	End of this day
Last 12 months	Start of month 12 months ago	End of this month

Static date range workaround

Since Between only supports relative time, use two conditions for a fixed date range:

Add filter: date_column After [start date] (static time mode)
Add filter: date_column Before [end date] (static time mode)
Combine with AND logic

This creates a static range that won’t change.

Filtering datetime values

When filtering datetime columns:

Default behavior: Full timestamp (date + time) is compared
Force Date: Enable to ignore the time portion and compare dates only

Force Date is useful when you want “all records from January 15th” regardless of what time they occurred.

Best practices

Use relative time for dashboards: Rolling windows keep things current without manual updates
Use static time for reports: Fixed ranges ensure consistent historical analysis
Consider time zones: Relative time uses the user’s configured timezone
Test with the preview: Use the info icon on Between filters to verify expected date ranges
Match precision to need: Use day-level filtering for daily reports, hour-level for intraday analysis