Date/Time

T

TomC

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
 
K

KARL DEWEY

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.
 
Top