Timestamp of another field's modification date?

[dmeyer]

Hello,

Is there a way to have a field automatically timestamp itself when another field in the same table is modified?

Something like:

Field1 <- user modifies the value in this field

Field1ModDate <- automatically stamps itself to track when Field1 was last updated.

Thanks

[LaRetta]

Hi dmeyer,

There are a few ways; here are two:

1) Make your Field1ModDate a standard timestamp field. In Options, set it to auto-enter by calculation:

[color:blue]Case ( field1 ; Get ( CurrentTimeStamp ) ; Get ( CurrentTimeStamp ) )

Back at the auto-enter tab, uncheck below calculation where it says 'Do Not Replace Existing Value...'

2) just make it a calculation instead using above calc.

LaRetta