Automatically put in current date

[rg2005]

How do you automatically put in the current date in a table?

 

[statsman]

Open the table in design mode.

For the field you want the date, ensure that date/time is selected.

In Default Value enter Now()

In a form you can do the same thing. You can also select the format:

Long date: Tuesday December 13, 2005

Medium Date: 13-Dec-05

Short Date: 12/13/05

 

[neileg]

Actually, Now() returns the date and time. If you only want the date use Date().

 

[rg2005]

thanks for the help,