Converting DateTime Data

[Steve]

I have a large file which has date/time fields which I need to convert to
simply date (so that I can match up the dates to some look-up tables I have).
I know how to change the format in the table, but that only seems to change
how you see the data, not the data itself, so the dates still will not match
up to my look-up tables. Is there a way to permanently change a date/time
field to simply date? Any advice will be greatly appreciated!

 

[Douglas J. Steele]

Are you sure you're never going to need the time?

The DateValue function will return just the date. You could put that into a
query and use the query rather than the table.

If you're positive you won't need the time, you could write an Update query
that updated the field to DateValue([the field])