Format Text field data as Date

[razorking]

Well I have been searching but have not exactly found the answer I need so:

I have a linked table in my database. One of the fields on the source table is a date field but the data type is Text. So there is data in the field that represents dates but they are formatted as text like this:
090506
101106
120506

I need the field data to behave as a date, any ideas? I can't change the source data type.

Then...at some point I want to produce a query that shows all records with a date earlier than the current days date...in pointers in the right direction on that will be appreciated also.

Thanks!

 

[FoFa]

Look at the dateserial function and parse you date into what it requires.