HELP Adding a Date to the field

[Darrin]

Hi all
As I add new records to my table, I want to have the date the record was
added to the table automatically put into a "DateAdd" field.

Any help in doing this will be much appreciated.

the records are moved to one table (without DateAdd" field) to another
which has the "DateAdd" field.

 

[Darrin]

Ah, this will work
=Format(Date(),"mm dd yyyy")

 

[t t via AccessMonster.com]

you can put at design view of table which includes DateAdd field. Select
DateAdd field and type it's default value array DATE() . Before doing
this you must select the type of field as short date. So when you add new
record this field will be filled with the current date.