changing a datetime field to just a date field in an access table

J

jaimee001

I have a table in access that contains a datetime stamp. I REALLy don't want
to have to reimport so is there an easy way to change the field to a date
stamp...
 
D

Douglas J. Steele

DateValue(MyDateTimeField) will return only the date portion.

You can either create a query that applies that function, and use the query
wherever you would otherwise have used the table (just in case you change
your mind later...), or you can write an Update query that reassigns the
field the truncated value.
 
Top