I have a Database and form and I want that each time I enter a new record from the form the table will put the date or date time stamp in the table.
Hi
You can define this with TOOLS
SQL
, execute something like:
ALTER TABLE "Table1" ALTER COLUMN "DATE" SET DEFAULT CURRENT_TIMESTAMP
Where DATE is the column name.
See CurrentDate.odb: date is added on saving the record
Regards