Plebuch Posted January 14, 2001 Posted January 14, 2001 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 Posted January 14, 2001 Posted January 14, 2001 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 Posted January 15, 2001 Author Posted January 15, 2001 Cool! It works. Sorry about posting your answer -- I was trying to send a big THANKS!
Recommended Posts
This topic is 8698 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now