I'm currently using FM 9 and I'm trying to figure out a way to capture the date that a notes field was last modified. We may be getting FM 11 in a few weeks, so for now I wanted to do this without using a script. I thought maybe I could do it with a calculation function but I can't find one that looks like it can capture what I'm looking to capture. My database is already set up to capture the last record modification date. I want to capture the last date that one field was modified. Does anyone know of a way this can be done with FM 9?

Hi

create a date field that auto-enters ( unflag the "Do not replace existing value...") this calculation:

Let(

trigger = YourField ;

Get ( CurrentDate )

)

YourField is the field for which you want to capture the modification date

Thanks for the response! It doesn't quite do what I want it to do though. It is putting in the date if I add a note to the Notes field. But if there is text already in the Notes field it still displays the current date, which isn't the date the field was last edited.

Hi SGordon,

Maybe this file New Note First by Database Pros does what you are wanting.

Lee

But if there is text already in the Notes field it still displays the current date, which isn't the date the field was last edited.

If there is a text, but the field get modified, the current date will appear.