Converting text to date in Access query

[Universal]

I am querying off of a linked table that contains a date that is in TEXT format with the following structure: "yyyymmdd." The structure of the output is agreeable with the rest of my data, but the format is not. Is there a way to get the query reults in DATE FORMAT?

With my current data, when I export to excel and try to give it a date format I get errors when I try to upload the data back into an access database.

Is there code that will work in the query? I can't change the format of the linked table I am pulling from. Somebody please help!

Thanks,
Nick

 

[Philem]

Hullo. One way around this would be to have a field in your query something like this:

FormattedDate:MID(field,5,2)&"/"&RIGHT(field,2)&"/"&LEFT(field,4)

That would turn 20040708 into 07/08/2004 for M/D/Y format.

HTH

P