Now time and date for each record entry 1

[teser]

When inputting a record I want to have a field value that shows the time and date the record was entered. My three fields are ID(Autonumber Primary Key),Name and date. So each time a Name is entered it automatically enters the date and time of the entry. How can I get this to work??


ID Name Date
1 John 6/24/02 8:00 AM
2 Mike 6/25/02 12:23 PM

 

[oharab]

Probably the easiest way is to set it in the table definition.
In the "Default Value" of the field, put Now() and every time a new record is created it will automatically put the current time and date.

Ben ----------------------------------
Ben O'Hara
bo104@westyorkshire.pnn.police.uk
----------------------------------

 

[teser]

Thanks

 

[Guest_imported]

When I've tried that in the past, only the date is entered and not the time. Any suggestions?

 

[fkegley]

Change the Format of the Date column to General Date.

fkegley@hotmail.com