Text to date conversion

[LG]

I tried the 2 ideas date serial and the cdate but still get a blank field.
I have the date that imported from a text file in to access as a text field
the date reads 20080401 and i need it to read 4/1/2008. I tried the update
query with adding an additonal column as a date field and than doing the
update query all I got were blank fields in both.
The original field was dte_filled (text) and the new one date_filled
(date/time). I put the update query with the update to
DateSerial(Left([DATE_FILLED],4),Right(Left([DATE_FILLED],6),2),Right([DATE_FILLED],2))
I have been trying this for a few days and still need help.
Thanks

 

[Beetle]

You said the original field is dte_filled (no a in date) and
the new field is date_filled, so you would want to use the
original field in the DateSerial function;

DateSerial(Left([dte_filled],4),Mid([dte_Filled],5,2),Right([dte_Filled],2))

 

[Douglas J. Steele]

CDate(Format([dte_filled], "@@@@\-@@\-@@"))