yymmdd

[Seb]

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?

 

[neileg]

When you import the data, does Access recognise this field as a date? If so all you need is the Format() function to change the display.

If it doesn't, I would think about using Left(), Mid() and Right() to chop out the data, assemble it in the right order and use CDate() to turn it into a true date. Then use Format() to get what you want.