Yymmdd

howdy all!!

I'm sure its pretty easy but I've got no idea ho to do this....

I've got a DB that imports a CSV file with a few hundred records. I run some queries on the data and kick out some Excel reports. The question I have is that the CSV file has a date field which is in yymmdd format but here in OZ we work with ddmmyy....
How would I format a field like this to be in the format I want?