Setting date when field is modified

[ljm]

I have a status field for which I would like to store a date when it is modified. I have Status and Date fields, but don't know the best way to evaluate the contents of the status field for a change - should I make a temporary field which stores what ever is in the status field and when the user leaves the record the temporary field gets replaced and then sets the date if needed?

Thanks

[LaRetta]

Create a calculation (date) with this:

Let ( trigger = Status ; Get ( CurrentDate) )

The calc will not evaluate and change the current date unless Status has been modified.

If ( Status ; Get ( CurrentDate ) ; Get ( CurrentDate ) ... will work as well but it might confuse you later on what it meant. Calling it trigger removes all doubt. ^)

[Lee Smith]

I am not sure I'm fully understanding what your set up, but I'll take a crack at it.

One way to follow modifications is to do an Audit File, there are examples if you need one. These are set up to follow the changes of one or more fields, and record what changed and where.

On the other end of the spectum, and probably the easiest way to record a modification of a Record is to use the Option in a date field of Modification Date. But the date will be update whenever any changes are made to any field in the record.

What it sounded like you are wanting is to record a date for particular changes to the Status field. Probably having a date field to record each one of these steps. i.e. Open Project post a date to the date field for Open Project, Sent Bids, post a date to the Sent Bids Date Field, etic. If this is kind of what you mean, then either attach a copy of your file, or tell use what dates fields, and status changes you are wanting to follow.

HTH

Lee

[ljm]

Thank you! This works great.

The next comment is helpful too, I will look at Audit files, but mostly I just need to track a couple of status changes, and this fits the bill.