March 21, 200520 yr 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
March 21, 200520 yr Author 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
March 21, 200520 yr You can use this as a formula in a calculation field: Evaluate(quote(Get(CurrentDate));YourField)
March 21, 200520 yr You can use this as a formula in a calculation field: Evaluate(quote(Get(CurrentDate));YourField)
Create an account or sign in to comment