This topic is locked

Timestamp not updating...

12/6/2007 5:57:03 PM
ASPRunnerPro General questions
author

It's not the end of the world, but I'm wondering why the timestamp data in my application doesn't change each time a record is modified. The default value I use is Now() and the field is read-only. Any advice? Thanks.

S
stealthwifi 12/7/2007

If I am understanding you correctly you have a time stamp as Now() in a read only field and want that read only field to update every time the record is edited.
I would try using the Edit page > Before Record Update event on the table to assign a new now() value to the field.
I believe the reason the time stamp is not working for you is that it's only assigned the now() value when the record is created and since the field is read only no change can be made to it (being the new now() value) when it's being edited.