When you add a database view in Notion, you see two similar timestamp properties: Created Time and Last Edited Time. Many users confuse these two fields, leading to incorrect filtering, sorting, or reporting. Created Time records the moment a database item is first added, while Last Edited Time updates whenever any property is modified. This article explains the exact difference between these two properties, how each behaves under different editing scenarios, and how to use them correctly in your workflows.
Key Takeaways: Created vs Last Edited Time in Notion Databases
- Created Time property: Stores the exact date and time when a database item was first added. This value never changes unless you manually edit it.
- Last Edited Time property: Automatically updates to the current timestamp whenever any property of the item is modified, including title, checkbox, or formula.
- Filtering with both properties: Use Created Time to track item age and Last Edited Time to find recently updated items without scanning the entire database.
How Notion Handles Database Timestamps
Notion databases are built around the concept of items, which are rows in a table. Each item can have multiple properties, and two of those properties are special timestamp fields: Created Time and Last Edited Time. Both are automatically generated when you add a new database item, but they behave differently from that point forward.
Created Time is set once when the item is first created. This timestamp reflects the moment you press Enter after typing the item title or when you paste a new row into the database. After that, Created Time remains static. Even if you edit the item hundreds of times, the Created Time value does not change.
Last Edited Time, by contrast, is dynamic. Every time you change any property of the item — including the title, a select option, a checkbox, a formula output, or a relation link — Notion stamps the current date and time onto that property. This includes changes made by automations, integrations, or other users in a shared workspace.
What Triggers a Last Edited Time Update
Notion updates Last Edited Time for any of the following actions:
- Editing the item title
- Changing a text, number, or email property
- Toggling a checkbox
- Adding or removing a tag in a select or multi-select property
- Modifying a date property
- Adding or removing a relation link
- Updating a formula that depends on other properties (even if the formula output changes)
- Running a database automation that modifies a property
Actions that do NOT update Last Edited Time include viewing the item, opening the page, or adding a comment. Comments are stored separately and do not count as property edits.
Steps to Add and Use Created Time and Last Edited Time Properties
To use these timestamp properties, you must add them to your database. The process is the same for both properties.
- Open your database as a table view
Navigate to the database you want to modify. Make sure the view is set to Table so you can see all columns. - Add a new property column
Click the + icon in the last column header. A dropdown menu appears. - Select Created Time or Last Edited Time
Scroll down to the Advanced section of the property type list. Click Created Time or Last Edited Time. A new column appears with the current timestamps for all existing items. - Rename the property if needed
By default, the property is named Created time or Last edited time. You can double-click the column header to rename it, for example to Date Added or Last Updated. - Use the properties for filtering and sorting
Click the filter icon at the top of the database view. Add a filter condition like Last Edited Time is in the past 7 days to see recently modified items. For sorting, click the sort icon and choose Created Time descending to show newest items first.
Important: You Cannot Manually Edit These Timestamps
Created Time and Last Edited Time are read-only properties. You cannot type a custom date into them. If you need a timestamp that you can control manually, use a Date property instead. A Date property allows you to set any date and time, and it will not auto-update when other properties change.
Common Misunderstandings About Notion Timestamp Properties
Last Edited Time Updates When I Only View the Item
This is a frequent complaint. Some users report that Last Edited Time changes even when they did not edit anything. The cause is usually one of two things: an automation that modifies a property when the item is opened, or a formula that recalculates based on a dynamic value like Now(). If you have a formula that uses the Now() function, that formula recalculates every time the database loads, which may trigger a Last Edited Time update. To avoid this, do not use Now() in formulas if you want Last Edited Time to remain stable.
Created Time Differs Between Import Methods
When you import data into a Notion database from a CSV, Excel, or another tool, the Created Time property is set to the import timestamp, not the original creation date. If you need to preserve original creation dates, add a separate Date property before importing and manually set those dates. After import, you can hide or delete the Created Time column.
Last Edited Time Does Not Show Time Zone
Notion displays timestamps in your local time zone based on your workspace settings. If you share a database with users in different time zones, each user sees the timestamp converted to their own time zone. This can cause confusion when discussing deadlines or recent edits. To avoid this, consider using a Date property with a fixed time zone, or add a note in the database description specifying the reference time zone.
Created Time vs Last Edited Time: Key Differences Table
| Feature | Created Time | Last Edited Time |
|---|---|---|
| Set when item is first created | Yes, once | Yes, also set at creation |
| Auto-updates on property edits | No | Yes |
| Can be manually edited | No | No |
| Useful for tracking item age | Yes | No |
| Useful for finding recent changes | No | Yes |
| Affected by formula with Now() | No | Yes, can trigger update |
| Shows in database exports | Yes, as ISO 8601 string | Yes, as ISO 8601 string |
The table above summarizes the core behavioral differences. Use Created Time when you need a fixed reference point for when a task or entry was added. Use Last Edited Time when you need to monitor activity or sort by recency.
Now you can confidently choose between Created Time and Last Edited Time for your Notion databases. Start by adding both properties to a test database and observe how they behave after different edits. For advanced tracking, combine Last Edited Time with a Rollup property that counts days since last update. This gives you a clear view of stale items that need attention.