Date Modified

[Plebuch]

I have a field that I need to record when it is modified. When I use Date Modified, it records whenever anything is modified on the record. Can someone provide help so I can record when the specific field, only, is modified?

TIA

[LiveOak]

I gave this a try and it should work. Create a field:

FieldModDate (calculation, date ,stored,indexed) =

Case(

not IsEmpty(FIELD), Status(CurrentDate),

Status(CurrentDate))

The idea is that the result of the calculation doesn't depend upon the value of FIELD, but changing the value of FIELD will cause the stored calculation to update. The only downside is that if you modify FIELD by retyping the same value already in the field, the date will still update.

To change the date only when a different value is entered, it is necessary to create a second hidden field, compare the value to the previous value and update the date modified field if the value is different. This requires controlling access to the field and using scripts to update the value (and the date).

-bd

[Plebuch]

Cool! It works. Sorry about posting your answer -- I was trying to send a big THANKS!