show mod. date of a text field, not whole record

[ibiubu]

Is it possible to have a field/calculation that shows the date that a particlular text field is modified? The reason I want to do this is so I can have a layout/table that I can look at and see the dates that text has been entered into this particular text field.

I know I can show the date modified for the entire record, but don't know if it can be done for just a particular field.

LR

[mdpres]

Depending on how many fields you want to show modified date for you can set up a clone of a field with a auto enter calc ie: Name Clone = Name then have a date field with a calc such as Case(Name Clone <>Name, Today,Name Clone = Name,DateToText("")) that way if Name field is changed date will enter.

Dean

[Kundinger]

Hi LR,

What you are looking for is sometimes referred to as "Auditing". This allows you to track 'changes' to specific fields.

I have a sample file that shows how you could implement a "History" field to document any 'changes' to another specific field. It basically 'appends' any change to a field to a "History" field. You can also have it append the date, time, user, etc. to the "History" field.

E-mail me ([email protected]) if you would like to look at it.

Bob Kundinger