adding today's date to a table

[Janet Chapman]

I am creating a database for a video shop and in the loans table want
there to be a field for date taken, with a default value of today.
Trying to write =today() as in the help gives an error, while using
=date() adds todays date, but this changes as the date changes.
Please help.

Janet Chapman

[Big Time]

I have a table that does this. Fieldtype is Date/Time and in the Default
Value I have Date() (no "=" sign). Required is set to "no". This returns
today's date as the default however you can change it if you want. Maybe
I'm misunderstanding you but wouldn't you want the date to change as the
current date changes?


"Janet Chapman" <ja*********@hotmail.com> wrote in message
news:85**************************@posting.google.c om...

I am creating a database for a video shop and in the loans table want
there to be a field for date taken, with a default value of today.
Trying to write =today() as in the help gives an error, while using
=date() adds todays date, but this changes as the date changes.
Please help.

Janet Chapman

[Larry Linson]

"Janet Chapman" <ja*********@hotmail.com> wrote in message
news:85**************************@posting.google.c om...

I am creating a database for a video shop and in the loans table want
there to be a field for date taken, with a default value of today.
Trying to write =today() as in the help gives an error, while using
=date() adds todays date, but this changes as the date changes.
Please help.

I don't understand what you mean by "changes as the date changes" -- the
default value for a field is only used when a new record is created, and
that is what I understood that you wanted. Because it is a "default" value,
the user can overtype it in a form and the user's value will be what is
stored.

I also am not certain why you thought that Today() was an Access built-in
function. Perhaps you are thinking of some other software?

Larry Linson
Microsoft Access MVP

[janet chapman]

Thank you for your response. I wanted the date for each record to
default to the day that record was created, and not update itself to
todays date, which is what happens with Date().

Janet
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[gj]

Janet Chapman wrote:

I am creating a database for a video shop and in the loans table want
there to be a field for date taken, with a default value of today.
Trying to write =today() as in the help gives an error, while using
=date() adds todays date, but this changes as the date changes.
Please help.

Janet Chapman

Add the field to the table.
In the table definition set the default value to DATE(). If you wnat it
to store the data and time set the default value to NOW() ensuring you
have selected GENERAL DATE as the first optiojn in the properties.

Alternately, you can set the default value in a form but my preference
for these fields is the table.

Have fun.

GJ

[Abhorsen]

i too am trying to do this but i get a compile error if i save when trying to switch out of design view. any ideas?