turning a string into a date

[imintrouble]

Hello! I am doing a project which currently requires me to input a new file we just got. However, the dates on all of them, as in the field containing the dates, displays something like 20030608 instead of June 8, 2003. I was thinking I could just run the file through a looped vb array to go through the information, reformat it, and then dump it into a new column. If any other information is needed, please feel free to ask.



Thanks!

[alansidman]

You could do this in a query. Separate the date string into three fields, day, month and year using the right and left functions. In a fourth field you could combine into the date format you want using the format function.

[pdebaets]

You can update the new column with one sql statement like so:

CurrentDB().Execute "Update MyImportTable Set MyNewDateField = cdate(mid(MyImportedDateField,5,2) & '/' & right(MyImportedDateField,2) & '/' & left(MyImportedDateField,4));"