Date/Time

[Guest]

I messed up when I created the table by giving the Date/Time Field a default
of "Now()" instead of "Date()" - I don't need the time. So what can I do to
(a) change the Date/Time field to just the date and (b) change the table to a
default of "Date()" without messing up everything again.
Thanks, Tom

 

[Guest]

First back up the database.
Open the table in design view, click on the field name, and then on the
Default property. Change to Date() and save. You may get a warning - click
OK.

Create an update query for the field. In the Update To row enter --
Int([YourDateFieldName])

This will strip any time part from the entries.