Heya guys

I have got a database that has got a field in it that stores a date in the following format "17 October 2008" however it is set as a varchar field. I want to query this field to get all the records between two specific dates. I have tried changing the field to a date field however it wipes all the data that is already inserted into it (over 1500) entries. Is there anyway that i can do this?

Thank you in advance

Frosty