In my table i have a field with list of record like 12091999 as a type Text. how can i change all the record under that field into format like 12/09/1999 by giving Date/Time data type.
In my table i have a field with list of record like 12091999 as a type Text. how can i change all the record under that field into format like 12/09/1999 by giving Date/Time data type.
An approach would be:
Create a new field in your Table with type Date, say MyDate.
Create a query with the text field in question ( the string "12091999"). Let's say this field is txtDate.
UPDATE testCharDate
SET testCharDate.MyDate = CDate(Left([txtField],2) & "/" & Mid([txtField],3,2) & "/" & Right([txtField],2));