automatically inserting a date

[michellerobinso]

the people that i am creating a database for are wantingto have a "date" field but they dont want to manually input it. they would like the date to automatically update to todays date when they start entering the details.

can this be done?

many thanks

michelle

 

[KenHigg]

You can do this at the table level or in the form by setting the 'Default Value' property to =date()

 

[michellerobinso]

thanks.

are you able to do something similar with the auto number.

i'd like it to display R/N "month" auto number "year".

i cant seem to get it to display the month and year

 

[KenHigg]

Auto number as in a field type autonumber?

I think you just need to set up the fields 'format' property to change the way the date is displayed... ???

 

[michellerobinso]

ive tried that but it doesnt seem to be working.