make table query

[kerrigirrl]

i'm splitting up a field, 1082 characters long, text, into 5 different fields. but when i do a "Date: Mid([Field1],62,8)" in the make table query, it automatically makes it a text field. how can i change this to a date/time with short date format???

thanks in advance!

kerri

 

[tlbroadbent]

Use the CDate function.

Date: CDate(Mid([Field1],62,8)) Terry Broadbent
Please review faq183-874.

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin