Imported records use dashes instead of slashes for dates

E

Ernie

Have a large database, just imported 1,000 more records into it from an ASCII
file. However, the date fields in the imported data uses dashes (01-01-2005)
instead of slashes (01/01/2005) and there are three characters at the
beginning of the date that need to go away on each imported record.
Looks like this: 98-01-01-2005
Needs to look like 01/01/2005

Any easy way to do it?
 
K

KARL DEWEY

You need to check the table created on the import as I would think that the
field is a text field and not a datetime filed.
If it is you need to insert a new field (DateTime) and run an update query
to get the dates in the DateTime field.
 
Top