Capturing field modification date

[SGordon]

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?

[Raybaudi]

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

[SGordon]

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.

[Lee Smith]

Hi SGordon,

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

Lee

[Raybaudi]

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.