Field Modification Date

[mad_mickey]

Can anyone give me a calculation to automatically enter a field modification date, i.e. in my database I would like an approval date automatically entered when a user modifies info in a user field.

I am fully aware of Record Modification Date but I only want this date entered when info is modified in the specific user field.

[Steven H. Blackwell]

Define a calculation field called "Mod_Track" of type text. It must be a stored calculation.

To watch the filed "User_Field":

"Mod_Track"= [if(User_Field, Status(CurrentUserName), Status(CurrentUserName))]

Everytime a change is made in the field "User_Field", the "Mod_Track" field will update.

FWIW, this is usally set up to include the date and time as well.

HTH

Old Advance Man