I have a TEXT field which contains a Date in a Table in an ACCESS Database

I want to select records from the table using an SQL Statement


eg, Select * from Table where DateField between...