updating date format

[john c]

I imported a table and the date format is Aug 24 2004. I
want to change that to a standard mm/dd/yy format. I
would like to automate this process. Can I do this
change using an update query and if so how?

 

[Wayne Morgan]

What data type is the field? If it is a date/time field, then all you need
to change is the format for that field and/or the controls that display it.
If the field is text, it can be changed using an update query, but usually
you will want the field to be a date/time type. Also, I would recommend 4
digit years.

UPDATE Table1 SET Table1.Field1 = Format(CDate(Table1.Field1), "mm/dd/yy");