Modification Dates

[Jacob]

Does anyone know how to create a field that will show the modification date of another field? For example, I'd like to keep track of when a client's address has been updated, and not just when his overall record has been modified. I'm assuming this is relatively easy (in fact, I could just put his address info in a separate table with a basic modification date field, but I try to keep my total number of tables and relationships down)

Thanks

[Jacob]

Does anyone know how to create a field that will show the modification date of another field? For example, I'd like to keep track of when a client's address has been updated, and not just when his overall record has been modified. I'm assuming this is relatively easy (in fact, I could just put his address info in a separate table with a basic modification date field, but I try to keep my total number of tables and relationships down)

Thanks

[BobWeaver]

You can use this as a formula in a calculation field:

Evaluate(quote(Get(CurrentDate));YourField)

[BobWeaver]

You can use this as a formula in a calculation field:

Evaluate(quote(Get(CurrentDate));YourField)