Auto insert date

[Rescueme]

I am working with MS Access97 and have a table with four fields. When I add
a new record to the table I would like the fourth field to add the current
date and time.

Field One - Ref#
Field Two - Description
Field Three - Assigned_To
Field Four - Date_Assigned

Date in the format of DD/MM/YYYY HH:MM

Thanks in advance for the help
Karen
(e-mail address removed)

 

[Rick Brandt]

I am working with MS Access97 and have a table with four fields. When I add
a new record to the table I would like the fourth field to add the current
date and time.

Field One - Ref#
Field Two - Description
Field Three - Assigned_To
Field Four - Date_Assigned

Date in the format of DD/MM/YYYY HH:MM

Just make Now() the default value for the field.

 

[Fritz]

Just enter Date() and select the date format you want.

Regards,


Fritz