Skip to main content

Add `CHANGED_TIME()` formula function

  • November 15, 2015
  • 3 replies
  • 32 views
S
Forum|alt.badge.img+4

Continuing the discussion from Created / Modified Timestamps:

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.

    D
    O
    D

    3 replies

    S
    • Stuart_Brameld
    • Participating Frequently
    • January 4, 2016

    +1 for this

    adding some love to hit 20 characters :heart: :slightly_smiling_face:

    F
    R
    A
    Forum|alt.badge.img+8
    • Andrew11
    • Participating Frequently
    • January 22, 2016

    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()

    C
    K
    Forum|alt.badge.img+4
    • Kasra
    • Inspiring
    • September 4, 2019

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

    Terms & ConditionsAccessibility statement