# Time of creation

**URL:** <https://gramps.discourse.group/t/time-of-creation/3540>\
**Category:** Help\
**Created:** [April 20, 2023, 4:23pm UTC](https://gramps.discourse.group/t/time-of-creation/3540 "2023-04-20T16:23:44Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![CQL](https://avatars.discourse-cdn.com/v4/letter/c/a5b964/32.png) [@CQL](https://gramps.discourse.group/u/CQL)\
**Post date:** [April 20, 2023, 4:23pm UTC](https://gramps.discourse.group/t/time-of-creation/3540/1 "2023-04-20T16:23:44Z")

</div>

Hi everyone. Is there a way I can see the date I created / modified an element (person, note, etc) in Gramps?

Thanks!

---

<div class="post-metadata">

**Author:** ![GeorgeWilmes](https://avatars.discourse-cdn.com/v4/letter/g/c57346/32.png) [@GeorgeWilmes](https://gramps.discourse.group/u/GeorgeWilmes)\
**Post date:** [April 20, 2023, 4:44pm UTC](https://gramps.discourse.group/t/time-of-creation/3540/2 "2023-04-20T16:44:33Z")

</div>

The creation timestamp is part of the object’s handle. [Here’s](https://gramps.discourse.group/t/handle-and-change-columns-in-sqlite-export/986) an example of how to decode it using SQL.

---

<div class="post-metadata">

**Author:** ![CQL](https://avatars.discourse-cdn.com/v4/letter/c/a5b964/32.png) [@CQL](https://gramps.discourse.group/u/CQL)\
**Post date:** [April 20, 2023, 5:00pm UTC](https://gramps.discourse.group/t/time-of-creation/3540/3 "2023-04-20T17:00:33Z")

</div>

Thanks for the answer. I assume then that there’s no way to access this info / filter elements based on time criteria directly from Gramps, not even with an add on, isn’t it?

---

<div class="post-metadata">

**Author:** ![GeorgeWilmes](https://avatars.discourse-cdn.com/v4/letter/g/c57346/32.png) [@GeorgeWilmes](https://gramps.discourse.group/u/GeorgeWilmes)\
**Post date:** [April 20, 2023, 5:16pm UTC](https://gramps.discourse.group/t/time-of-creation/3540/4 "2023-04-20T17:16:05Z")

</div>

I think it should be possible to use Python to code a new filter rule that could be use in custom filters. With more effort, a “Created” column could be added to the views. But no, nothing out-of-the-box, as far as I know.

---

<div class="post-metadata">

**Author:** ![emyoulation](https://yyz2.discourse-cdn.com/free1/user_avatar/gramps.discourse.group/emyoulation/32/67_2.png) [@emyoulation](https://gramps.discourse.group/u/emyoulation)\
**Post date:** [April 20, 2023, 5:16pm UTC](https://gramps.discourse.group/t/time-of-creation/3540/5 "2023-04-20T17:16:14Z")

</div>

> [@CQL](#):
>
> Thanks for the answer. I assume then that there’s no way to access this info / filter elements based on time criteria directly from Gramps, not even with an add on, isn’t it?

There is. In each of the Categoary Views showing tables, you can add more columns to the table. A common column you can add is the “ **Last Changed** ” data.

Use the “Configure…” option in the View menu. This opens the [Column Editor](https://gramps-project.org/wiki/index.php/Gramps_5.1_Wiki_Manual_-_Settings#Column_Editor) where you can add available columns.

 ![image](https://global.discourse-cdn.com/free1/uploads/gramps/original/2X/5/5b4e826cbfe4fccfa63c8badb09eab16f8ca376c.png)

**Note:** remember to click the Apply button before Close

You may also want to use the [Last Modified](https://gramps-project.org/wiki/index.php?title=Addon:Last_Modified) Addon. (It won’t work with the old BSDDB database engine from Gramps 5.0 and earlier.)

---

<div class="post-metadata">

**Author:** ![CQL](https://avatars.discourse-cdn.com/v4/letter/c/a5b964/32.png) [@CQL](https://gramps.discourse.group/u/CQL)\
**Post date:** [April 20, 2023, 5:38pm UTC](https://gramps.discourse.group/t/time-of-creation/3540/6 "2023-04-20T17:38:24Z")

</div>

Thanks both, using the column editor to activate “Last changed” works great (I wish there was also a “Created” colum to choose)

I’m loving this program 🙂

---

<div class="post-metadata">

**Author:** ![emyoulation](https://yyz2.discourse-cdn.com/free1/user_avatar/gramps.discourse.group/emyoulation/32/67_2.png) [@emyoulation](https://gramps.discourse.group/u/emyoulation)\
**Post date:** [April 20, 2023, 5:47pm UTC](https://gramps.discourse.group/t/time-of-creation/3540/7 "2023-04-20T17:47:56Z")

</div>

> [@CQL](#):
>
> (I wish there was also a “Created” colum to choose)

After looking through the Gramps [Data Model](https://www.gramps-project.org/wiki/index.php/Gramps_Data_Model) diagram and some developer docs, I see no mention of calls for a separate Creation Date timestamp.

I believe the Last Changed datestamp is absolutely needed to control the session-level commits to the Tree database. It is part of the support for an Undo queue. A Creation date isn’t needed for any other feature. (The base Last Changed date timestamp IS initailized with the creation date.)

---

<div class="post-metadata">

**Author:** ![SNoiraud](https://yyz2.discourse-cdn.com/free1/user_avatar/gramps.discourse.group/snoiraud/32/72_2.png) [@SNoiraud](https://gramps.discourse.group/u/SNoiraud)\
**Post date:** [April 20, 2023, 6:07pm UTC](https://gramps.discourse.group/t/time-of-creation/3540/8 "2023-04-20T18:07:27Z")

</div>

You can change the tab order. By default the first column is sorted.

 ![date-modification](https://global.discourse-cdn.com/free1/uploads/gramps/original/2X/b/bdd59badc58ef9b82d1c7cebec0ee74ab7cec311.png)

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/free1/uploads/gramps/original/1X/2ac1e712b7adf612e31ca08a55419f4cf37c0158.png) [@system](https://gramps.discourse.group/u/system)\
**Post date:** [May 20, 2023, 6:07pm UTC](https://gramps.discourse.group/t/time-of-creation/3540/9 "2023-05-20T18:07:51Z")

</div>

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.
