How to convert text format date to date format mm/dd/yyyy

[sushmitha]

I have a date in my access table as yyyymmdd whose datatype is text

I am using format([date], "mm/dd/yyyy") to convert to date in mm/dd/yyyy

It is throwing error #Error

Can anybody help me on this

 

[Mike375]

This would probably be a "work around" way

Mid([abc],5,2) & "" & "/" & "" & Right([abc],2) & "" & "/" & "" & Left([abc],4)