Add `CHANGED_TIME()` formula function

[Sashman]

Continuing the discussion from Created / Modified Timestamps:

Created / Modified Timestamps

Is there a way to get a record’s creation and/or last modified timestamp?

Perhaps using a formula field or through meta info provided through the API?

~ Tim

Currently CREATED_TIME() exists, but not CHANGED_TIME().
I suppose CHANGED_TIME shouldn not be updated when table schema is altered, e.g. when ‘{username} caused a change due to modifying a column’ message is logged in records’ histories.

[Stuart_Brameld]

+1 for this

adding some love to hit 20 characters :slightly_smiling_face:

[Andrew]

See thread here: Date Field AutoUpdate on Last Change/Addition

Unfortunately you’re right that we don’t have an equivalent formula for CHANGED_TIME()

[Kasra]

For anyone that stumbles on this thread, the LAST_MODIFIED_TIME() formula makes this possible!

Last modified time [SOLVED] Product Suggestions

Hi folks. The last modified time field and the LAST_MODIFIED_TIME() formula function are now available for all! You can learn more about it in this support article. [modifying] A couple of things you might want to know about these two new features: If you only care about changes made to certain fields (e.g. just wanting to know when the value in a Status field has been modified), then you can set this specification in the field customization menu or when setting up the formula, e.g. , LAST_…