JS-Q1: Hard coding date

[Jack Sheet]

Hi all

I want to hard code a date/time stamp in a field dedicated for that
information within a record, that shows the system date/time at point of
creation of the record (presumably the point of initial saving of the
record). The content of this field should never subsequently change.

In a separate field I want to hard code a date/time stamp of the latest
occasion when any field in the record has been modified (this will initially
be set to the same date/time as the creation date/time field as above).

This sounds like a standard sort of thing that is done regularly. Any help
fully appreciated, thanks.

(PS ignore the JS-Q1 in the subject line, that is just so that I can find
the thread easily)

 

[Rick B]

Do a search. The topic "timestamping records" is discussed all the time. I
have seen several posts just in the last few days.

Use the "default value" for the added date/time.
Use a code in the "before update" event to store the changed timestamp.