I have completed the code to change the string to Date (only) but when this code was tested there is something going wrong as the selected date is not returned in the table.

The conversion to date was completed in "Scheme.ini" file. I don't know if this is wrong or not as it's the first time that I convert a string to date.

Also I used the below code to select the period, but unfortunately it fails.

"INSERT INTO X " & _
"SELECT * " & _
"FROM Z WHERE Type = '20' and Date between #" & Text9.Text & " # And #" & Text10.Text & "#"
Any help please?