MSAccess settings

alastairwg

Distinguished
Feb 16, 2011
1
0
18,510
Hello,

Has anyone had the problem of opening a file with dates of the form yyyymmdd. When I try it tries to make it an American date, so 20090802 comes out as 08/02/2009 whereas 20091215 cannot be converted.

Is there a setting I need to change