update log

[Robert707]

Hi,

I got the following question. We would like to trace for 3 fields in a specific table the last change-date. So I don't want to know the last change date for the complete record, but only the last change date for some specific fields.

So let's say that in Table "Customers" I've got 3 fields:

City

Zipcode

Street

I've added 3 new fields in the same table:

City_change_date

Zipcode_change_date

Street_change_date

Now my question is: how do I get this change date in these new fields? Can I use scripting for this?

Hope someone can help me out, thanks in advance for your help!

Regards,

Robert

[Salesman0Gil]

Make another field. A yes box perhaps. That will detrime if the record is supposed to be modified.

Then script

Find(Restore) "yes, the ones to be modified"

Loop

Copy City Change

Paste in to City

Copy Zipcode Change

Paste in to Zipcode

Copy Street Change

Paste in to Street

Exit Loop if (status(current record number)=status(current found count)

Next record

End Loop

That should go through every record you foun, and coy and paste all the way through. Probably a better way to do it, but that is what came first to my mind.

[BobWeaver]

You don't need a script. You can set up your change date fields as stored calculation fields like this.

City_change_date:

Case(City,Status(CurrentDate),Status(CurrentDate))

Zipcode_change_date:

Case(Zipcode,Status(CurrentDate),Status(CurrentDate))

Street_change_date:

Case(Street,Status(CurrentDate),Status(CurrentDate))

[Robert707]

Hi guys,

Thank you both for your reply!

I've used Bob's solution, I think that's the cleanest way of solving it and quite easy to implement.

Thanks!!

Robert