When you work with a Notion database that already has data, you may want to track exactly when each entry was added. The Created Time property captures the precise date and time a new row is created, but this field is not automatically present in existing databases. This article explains how to add a Created Time property to any database that already contains entries. You will learn the exact steps to enable it and how to use it for sorting, filtering, and automation.
Key Takeaways: Adding Created Time to a Notion Database
- Database property menu > Add a property > Created Time: Adds a read-only timestamp that records when each row was first created.
- Sort by Created Time descending: Shows newest entries at the top of the database view.
- Filter by Created Time range: Lets you isolate entries added within a specific date window.
What the Created Time Property Does and Why You Need It
The Created Time property is a system-generated timestamp that Notion assigns to each database row the moment it is created. Unlike manual date fields, this property is read-only. You cannot edit or delete the timestamp after the row exists. This makes it a reliable audit trail for when entries were added.
You might need this property for several reasons. If you manage a project tracker, Created Time tells you when a task was logged. If you maintain a customer database, it records the sign-up date. The property also enables advanced workflows: you can sort views by creation date, filter for entries from the last seven days, or use it as a condition in Notion automations or formulas.
There is no prerequisite for adding this property. It works on any database type — table, board, timeline, calendar, list, or gallery. The property applies retroactively: once added, it will show the creation time for every existing row, not just new ones. Notion determines the creation time based on when the row was first added to the database, not when the property was inserted.
Steps to Add a Created Time Property to an Existing Database
Follow these steps to add the property. The process is identical on the Notion desktop app, web app, and mobile app.
- Open your database
Navigate to the page that contains the database. Click on the database to open it in full-page view or edit it inline on the parent page. - Locate the property menu
Look at the top of the database. You will see the column headers. Click the + button that appears to the right of the last column header. Alternatively, click any existing property name and select Properties from the dropdown, then click Add a property. - Select the Created Time type
From the property type dropdown, scroll down to the Advanced section. Choose Created Time. A new column appears with the default name “Created” and a date-time value for every existing row. - Rename the property (optional)
Click the property name at the top of the column. Type a new name such as “Entry Date” or “Row Created”. Press Enter to save the change. - Configure the display format (optional)
Click the property name again to open the property settings. Under Date format, choose a format: Relative (shows “2 hours ago”), Date (shows “Mar 15, 2025”), or Date and Time (shows “Mar 15, 2025 3:45 PM”). The default is Date and Time. - Use the property in views
Click the Sort button at the top right of the database. Add a sort rule: select the Created Time property and choose Descending to show newest entries first. To filter, click Filter, add a condition based on the Created Time property, and set a range like “On or after” a specific date.
The property now appears in all views of the database. If you switch to a calendar view, the Created Time property determines the date each entry appears on the calendar. In a board view, you can group cards by the Created Time property using a date range.
Common Mistakes and Limitations When Using Created Time
Created Time shows the same value for every existing row
This is not a bug. Notion assigns the Created Time based on when the row was first added to the database. If you import data or copy rows from another database, the creation time may default to the import time or the time the copy was made. To preserve original timestamps, use the Last Edited Time property instead, or manually enter dates in a separate Date property.
You cannot edit the Created Time value
The property is read-only. If you need a modifiable timestamp, add a Date property instead. The Date property allows manual entry and can be updated later. Use Created Time only when you need an unchangeable audit log.
Created Time is not available in some database views
The property exists in the database schema but may not display as a column in all views. For example, in a gallery view, the property is hidden by default. To show it, click Properties in the view toolbar, then toggle the Created Time property to visible. In a board view, you must add the property as a card preview to see it on each card.
Formulas referencing Created Time return unexpected results
If you write a formula that uses the now() function alongside Created Time, the formula recalculates every time the database is opened. This can cause confusing date differences. Use the prop("Created") reference in formulas to get the static creation timestamp. For example, dateBetween(now(), prop("Created"), "days") calculates how many days ago the row was created.
Created Time vs Last Edited Time vs Date Property: Key Differences
| Feature | Created Time | Last Edited Time | Date Property |
|---|---|---|---|
| Editable | No | No | Yes |
| Updates automatically | On row creation only | On every edit | Only when manually changed |
| Shows time | Yes (configurable) | Yes (configurable) | Yes (configurable) |
| Retroactive for existing rows | Yes | Yes | No (must be filled manually) |
| Use case | Audit trail for entry dates | Track recent changes | Custom deadlines or events |
Created Time and Last Edited Time are both system-generated and read-only. The Date property gives you full control but requires manual entry. Choose Created Time when you need an unchangeable record of when a row was added. Choose Last Edited Time when you need to know when a row was last modified. Choose Date when you need to set future dates or edit timestamps.
Now you can add a Created Time property to any existing Notion database. Use it to sort entries by creation date, filter for recent additions, or build formulas that calculate age. For advanced workflows, combine Created Time with Notion automations to trigger actions when a row has existed for a set number of days. The property is a simple but powerful tool for time-based data management.