Covert text date to date format

[TinaK]

I have a table that is imported from a text file. The date from the text file is stored as "short text" in my access table. (2018012903:3913010100110201). I want to convert it to 01/29/2018. I have tried several different ways and nothing has worked. This is the closest I was able to get:
Expr1: Right([field3],2) & "/" & Mid([field3],7,2) & "/" & Left([field3],4)
Results
test1

Field3	Expr1
2018012903:3913010100110201	01/29/2018
2018012807:2112770110110402	02/28/2018
2018012807:3512780120110402	02/28/2018

As you can see, the first one is correct, the others are not.

After I convert it to a date, I want to use "between #xx/xx/xx# and #xx/xx/xx#.

 

[TinaK]

JohnXL, thanks for the input.