querying between datetime based on String Date in YYMMDD format

[aero]

I'm brand new to sql, vba, and access, but I have a basic knowledge of object oriented programming in java, and python. I am trying to do a query between two dates selected on a form. The "Report_Period" Column of the table in this database is a 10 digit String in "YYMMDD" format. Does anyone know the script/statement I can use to rearrange this string into something that a function like convert or cdate or some other function can use to convert either the entire column or at the very least, the selected dates into date time format that I can use to query from combo-box1 selection to combo-box2 selection using a <> statement ? Everything I've come across so far only works on DDMMYY formatted strings. Another possibility might be rearranging the string with left(), mid(), and right() and placing this inside a function like cdate, but I haven not been able to figure out the correct syntax for doing so. Any thoughts? I'm open to any and all suggestions, but please post the code if it works.

[ItsMe]

Here is a snippet that uses Left() and Mid() functions.
https://www.accessforums.net/program...tml#post222674