I know it is possible to have a field showing date the record was modified, but is it possible to show the date a particular field was modified?:?

Yes it is. This requires the use of a calculation field that is stored. Let's say the field you're watching is called "Name". And let's say that the value you want returned when the field changes is called "X", and that could be something like the modifier name, date, and time, etc.

The result field could be called "modtrack". Therefore:

modtrack=If(Name, x,x)

Be sure to store this calculation. When and if the field "Name" is changed, the modtrack will re-evaluate.

HTH

Old Advance Man

I notice on that rather that using the Today function, people are advised to use Status(CurrentDate).

For this calculation would I use

modtrack=If(Name, Today ,Today) or

modtrack=If(Name, Status(CurrentDate) ,Status(CurrentDate)

Thanks

quote:

---

Originally posted by Tom England:

I notice on that rather that using the Today function, people are advised to use Status(CurrentDate).

For this calculation would I use

modtrack=If(Name, Today ,Today) or

modtrack=If(Name, Status(CurrentDate) ,Status(CurrentDate)

Thanks

---

In practice how it usually turns out is that the value I called "x" is really a concatenation of UserName and Date and Time, and sometimes other info. I would NOT use the Today function here.

Old Advance Man

Sorry, are you saying that I should use:

modtrack=If(Name, Status(CurrentDate) ,Status(CurrentDate))

I don't need the modifier name time etc, just the date a particular field was modified.

Also, I have tried doing this with the above calculation and it works to a certain extent. It works on many of the records, but not on all of them! have you any ideas?: I am at a loss!!!

Thanks

[ December 13, 2001: Message edited by: Tom England ]

"I know it is possible to have a field showing date the record was modified,"

Well, I have problems getting it right. I want a record containing, UserName & CurrentDate & CurrentTime when the record was last modified. Can anyone show me EXACTLY how I do this?

I recommend that you download the development standards published online by CoreSolutions, available at http://www.coresolutions.ca. By applying these standards I have reduced my development time considerably.

But the basic idea here is to define date, time and text fields that auto-enter the Modification Date, Modification Time and Modification Username, respectively. Then, define a calculation field (text, unstored), e.g.:

zc_Record_Modification_Info_ut = "Last Modified by " & zc_Modified_Name_t & " at " & TimeToText(zc_Modified_Time_i) & " on " & DateToText(zc_Modified_Date_d)

Note that this approach lets you track record modification, not field modification, as is the subject of the original post.