If you have tried to use Notion’s Timeline view to track a project or event, you may have noticed that items without a date range appear as single points on the timeline. This happens because the view relies on specific date properties to determine the start and end of each item. When only one date property is set, the timeline cannot stretch an item across multiple days. This article explains how to set up the correct date properties so your tasks, events, or projects display as bars spanning their full duration.
Key Takeaways: How to Display Date Ranges in Notion Timeline View
- Add a Date property with end date enabled: This creates the date range that the timeline view uses to display a bar.
- Set the Timeline view to use the Date property as both start and end: In the view settings, choose the Date property under the Date field to show the full range.
- Use formula properties to calculate duration: Create a formula that subtracts the start date from the end date to show the number of days in a separate column.
Why Notion Timeline View Needs a Date Range
The Timeline view in Notion displays database items as horizontal bars on a calendar-like grid. Each bar represents a single item, and the length of the bar corresponds to the duration between a start date and an end date. If your database only has a single Date property without an end date, every item appears as a dot or a very short bar that spans only one day. This is a common point of confusion for new users.
The root cause is that the Timeline view requires a Date property that includes both a start and an end value. Notion’s Date property type can hold a single date or a date range. When you create a Date property, you can enable the “End date” toggle in the property settings. Without this toggle enabled, the property stores only one date, and the timeline cannot stretch the bar.
To display a proper date range, you must either modify an existing Date property to include an end date or create a new Date property that supports ranges. Once the property is configured, you tell the Timeline view which property to use for the date field. The view then reads both the start and end values from that property and draws the bar accordingly.
Steps to Display Date Ranges in the Timeline View
- Open your database in Notion
Navigate to the page that contains the database you want to view as a timeline. Click the database name to open it. - Add a Date property to your database
If your database does not already have a Date property, click the + icon in the last column of the table view. Select the Date property type. Name it something like “Start Date” or “Date Range.” - Enable the End date option in the property
Click the property name in the table header. In the property settings panel that opens, toggle on the End date option. This tells Notion that this property can hold two dates: a start and an end. - Add a view that uses the Timeline layout
Click the current view name at the top of the database. Choose Add a view. Select Timeline as the view type. Give the view a name such as “Project Timeline” or “Event Schedule.” - Set the Date field in the Timeline view
In the new Timeline view, click the Date field at the top of the view (or click the gear icon to open view settings). From the dropdown, select the Date property you created in step 2. The timeline will now display items as bars that stretch from the start date to the end date. - Enter date ranges for your items
Click any item in the timeline to open its page. In the Date property field, click the start date and choose a date. Then click the end date field that appears next to it and choose the end date. The bar in the timeline view will update immediately to reflect the range.
If you prefer to use two separate Date properties (one for start and one for end) instead of a single Date property with an end date, you can do that as well. In the Timeline view settings, under the Date field, you will see an option to choose a Start date and an End date property separately. This method works the same way but gives you more flexibility if you already have separate date columns in your database.
Displaying Duration in a Column
Once your timeline shows date ranges, you may want to display the duration of each item in a separate column. You can do this with a formula property.
- Add a Formula property
Click the + icon in the last column of the database. Select the Formula property type. Name it “Duration.” - Enter the formula
In the formula editor, type: dateBetween(end(prop(“Date Range”)), start(prop(“Date Range”)), “days”). Replace “Date Range” with the name of your Date property. This formula calculates the number of days between the start and end dates. - View the result
The formula column will now show the number of days for each item. Items without an end date will show a value of 0 or an error, depending on the formula.
You can also use dateBetween(prop(“End Date”), prop(“Start Date”), “days”) if you are using two separate date properties. This gives you a quick way to see how long each task or event lasts without looking at the timeline grid.
Common Issues When Displaying Date Ranges
Items appear as dots instead of bars
If an item shows as a single dot on the timeline, the Date property for that item does not have an end date set. Open the item page and ensure both the start and end dates are filled in. If the property does not show an end date field, go back to the property settings and enable the End date toggle.
Bars show the wrong length
If a bar is too long or too short, check that the Date property in the view settings is correctly set. If you are using separate start and end properties, make sure you assigned the correct properties to the Start date and End date fields in the view settings. A common mistake is swapping the two properties.
Timeline view does not show any items
If the timeline appears empty, the Date property may not be set on any items. Add a date range to at least one item. Also check that the view filter is not hiding items. Click the filter icon in the view toolbar and remove any filters that might be excluding items.
End date field is missing from the Date property
If you cannot see an end date field when editing an item, the Date property does not have the End date option enabled. Click the property name in the table header, find the End date toggle, and turn it on. This change affects all existing items in the database, so previously entered dates will automatically get an end date that defaults to the same day.
Notion Timeline View: Single Date vs Date Range
| Item | Single Date Property | Date Range Property |
|---|---|---|
| Property type | Date (end date disabled) | Date (end date enabled) |
| Timeline display | Dot or one-day bar | Bar spanning start to end |
| Duration visibility | Not visible without formula | Visible via formula or bar length |
| Data entry required | One date | Start and end dates |
| Use case | Deadlines or single-day events | Projects, trips, multi-day events |
The key difference is that a single date property is simpler to fill in but does not show duration on the timeline. A date range property requires two dates but gives you a full visual bar. Choose the approach that matches your data. For project management with tasks that span multiple days, the date range property is the correct choice.
You can now set up a Notion database with a Date property that includes an end date and configure the Timeline view to display items as bars. Next, try adding a formula to calculate the duration in hours or days. For advanced use, group the timeline by a Select property to see multiple rows of bars, or use the Zoom slider at the top of the view to switch between days, weeks, and months.