I currently have a table with dates as text fields e.g 0109

I need to turn all of them into the form 01/09/03 as a date/time field.

Is there any way of doing this???????:rolleyes:

Assuming that you have no year (and this year is substituted)

DateSerial(Year(Date()), Mid([MyDate], 3, 2), Left([MyDate], 2))