The datepicker

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.

Offset

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.

Exclude

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.

Note

Amplitude doesn't support using offset and exclude at the same time.

Exclude specific days

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.

How Amplitude handles excluded days

When you exclude days, Amplitude:

  • Removes the day and its value from the data window but still count it toward the window size.
  • Ignores the dropped day's value in the average calculation.

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.

Time input

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. 

Note

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.

Presets

The datepicker also supports presets to streamline repetitive analysis and ensure consistency across teams.

Using presets

Presets allow quick access to predefined time ranges, including:

  • Last 7 days
  • Last month
  • Year to date
  • Custom fiscal periods

When you select a preset, the datepicker automatically fills in the associated time range.

Custom presets

You can create custom presets for recurring analysis windows like product launches, campaigns, or testing periods. Presets can include:

  • Specific start/end dates
  • Relative timeframes (for example "Last 60 days")
  • Optional exclusions (like incomplete data or specific weekdays)

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.

Default presets

Users can also define their own default preset for a given project. This preset automatically applies when creating new charts.

Was this page helpful?

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.