auto date for record

[collegeprodigy]

is there an auto date function that will put today's date in a record so that the date will stay permanently?

someone told me to use the Date() function, but it doesn't work for what i'm trying to do. for example, let's say I create a record with the auto date (or today's date) 4/18/03. then i want to look at the record tomorrow (on 4/19/03). the record that i made on the 18th will show the date as the 19th.

so, if i want something like a date stamp (of when something was created) where the date will not change every time i view the record, what do i need to do? do i actually need to write my own code to do it?

 

[R. Hicks]

You use the "Default Value" property of the field in table design.

To populate with the Current Date use:

=Date() as the Default Value.

If you want the Current Date and Time use:

=Now() as the Default Value.

HTH
RDH