Ask Your Question
0

How do I make auto date entries in Base

asked 2015-06-18 06:14:28 +0200

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.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2015-06-18 07:34:49 +0200

pierre-yves samyn gravatar image

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

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2015-06-18 06:14:28 +0200

Seen: 1,302 times

Last updated: Jun 18 '15