access query DATE conversion from text 2

[heyjo1]

i've imported a DBF file where all non-numeric fields are TEXT formatted fields. as such, a typical date field reads like this: 111504 (which represents November 15, 2004)

which access function can i use to make this read like a date, i.e. 11/15/2004, so i can then make DATE caluclations?

i've tried Cdate, DateValue, Date, Date$, etc...and none seem to work.

 

[Golom]

About the only thing you can do is parse the values out of the text string and then convert them

DateValue = DateSerial (Val(Right(DateString,2)), 
                        Val(Left (DateString,2)),
                        Val(Mid  (DateString,3,2)) )

 

[heyjo1]

thanks golom for your fast and helpful response! worked like a charm !!