1

Auto enter current date when a field is updated?

Hello, I am wondering if there's a way to have a date field self populate with the current date whenever I make changes in a field. I have a database with a 'Notes' section, and it would be nice to know how old the info is. It's important that it's tied to a specific field as opposed to the record itself.

I don't have lot of experience with scripting, so doing this is currently outside of my abilities. If this is not possible, does anyone have any suggestions or workarounds? Thanks in advance!

2 replies

null
    • John_Halls
    • 2 yrs ago
    • Reported - view

    If NoteDate is a date field, put this in the Trigger after update of the Notes field.

    NoteDate := today()

    Regards John

      • studio
      • 2 yrs ago
      • Reported - view

      John Halls 

      Hi John, I just happened to look to see if there was a response yet and you just left one - thanks! I just got it to work. I had a colon after the field name and I think it was messing things up. Thanks again for your help!

Content aside

  • Status Answered
  • 1 Likes
  • 2 yrs agoLast active
  • 2Replies
  • 165Views
  • 2 Following