Sorry, didn't read some of those posts inbetween, CONVERT is a MSSQL function, won't work in Access.

I still dont think it should matter what country your dates are in, you should still be able to CDate in VBScript and then FormatDateTime to the way you want them, or even do Day(Date) MonthName(Month(Date)) Year(Date) etc... to extract the proper parts of the field in the proper order.