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!

2replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • John Halls
    • John_Halls
    • 2 mths ago
    • Reported - view

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

    NoteDate := today()

    Regards John

    Like
      • studio
      • studio
      • 2 mths 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!

      Like
Like1 Follow
  • Status Answered
  • 1 Likes
  • 2 mths agoLast active
  • 2Replies
  • 49Views
  • 2 Following