using dbman sql 2, with default templates,

is it possible to set 2 fields,
one which stores date record was added
one which stores date record was last updated.

I have played around with timestamp fields in mysql, but have not managed to get this to work.

Any help much appreciated.
Tim Ault
Oxford UK