This article helps you:
Understand nuances in the way the datepicker understands time
In Amplitude, you use the datepicker to select the timeframe of the analysis you're conducting. In many ways, it's intuitive, as it's something you've most likely seen in other software contexts. You can choose to analyze data collected between two dates, since a specific date, or in the last x days, weeks, or months, where x is a value you select.
However, there are nuances to the way the datepicker understands time.
When using Last, your queries return the data from the timeframe you specified, as well as the latest, still-incomplete interval.
For example, if you set the datepicker to the last 30 days, Amplitude retrieves data from the last 30 full days, and however many hours have elapsed today.
If you don't want data from the incomplete day, or are using a delayed batch ingestion system, use an offset. To use an offset, click +Offset in the datepicker, then enter the number of days to offset by.
To remove the offset, click 'X' near the Offset by text.
When using Since or the Last x days, weeks, or months options, you can also choose to exclude the current day, week, or month. This can be helpful when the entirety of data for the selected timeframe isn't available.
To exclude the incomplete time interval from your chart, click +Exclude in the datepicker and select the Incomplete Interval option. The current date is no longer framed in a dotted line and is excluded from your analysis.
Uncheck Incomplete Interval to revert this setting. Use the same process to exclude or include the current week, current month or current quarter.
Amplitude doesn't support using offset and exclude at the same time.
You can exclude specific days of the week from your analysis. This isideal for organizations that operate on custom schedules. For example:
Retailers can exclude Sundays when stores aren't open
SaaS companies can omit weekends to focus on workweek behavior
This exclusion affects not only chart visuals but also metric calculations like averages and rolling windows.
When you exclude days, Amplitude:
This means:
A 5-day rolling window remains a 5-day window.
If you exclude one of those days(for example, Sunday), Amplitude ignores its value.
Amplitude calculates the average using only the included days’ values.
This method avoids artificially low averages and maintains consistent windowing on charts.
When using Since or Between, you can narrow the range further by enabling time input. Time input enables you to enter a start time or an end time to add granularity to your analysis.
The datepicker's time input feature is only available for Event Segmentation and Funnel Analysis charts.
To enable time granularity, click +Time in the datepicker. After you enable it, enter the start or end times in hours, minutes, and seconds to accompany your selected date range.
To turn it off, choose click the 'X' near the entered time.
The datepicker also supports presets to streamline repetitive analysis and ensure consistency across teams.
Presets allow quick access to predefined time ranges, including:
When you select a preset, the datepicker automatically fills in the associated time range.
You can create custom presets for recurring analysis windows like product launches, campaigns, or testing periods. Presets can include:
Amplitude defines presets at the project level, and they're available across the project. Admins and managers can create, edit, and manage these presets in Project Settings.
Users can also define their own default preset for a given project. This preset automatically applies when creating new charts.
July 22nd, 2025
Need help? Contact Support
Visit Amplitude.com
Have a look at the Amplitude Blog
Learn more at Amplitude Academy
© 2025 Amplitude, Inc. All rights reserved. Amplitude is a registered trademark of Amplitude, Inc.