This is not strickly a vb question but there are vb aspects to the thing i am producing.

I have a table and the date fields have to be text (long story don't ask why)

I have a query in access, where basically i need that date in date format (not text). so heres the question, how do i convert the text into a date (in the text field it is in the format of dd/mm/yyyy eg 01/05/2000).

remember I am doing this in a query so i don't really want huge amounts of code.

Thanks