RE: Access Date question!!!

this is a common situation with over-intelligent databases in general. If you have yank dates set it will assume 01/06 as the 6th jan, however if you then feed it 20/06 it will realise you want a european date, but only for that date. This is typical microshaft(tm) trying do second guess what you want to do (like plug and pray). Tim Ward Senior Systems Engineer Please refer to the following disclaimer in respect of this message: http://www.stivesdirect.com/e-mail-disclaimer.html > -----Original Message----- > From: Web Master [mailto:webmaster@unni.com] > Sent: 30 November 2000 15:59 > To: php-general@lists.php.net > Subject: Access Date question!!! > > > Hello, > > Sorry for bringing a off topic question here. > > Did any one here used Access as the back end for their > database? If so, did they > had any problems with dates? > > I am facing a serious problem: > > When I try to insert a date into a access date field (it is > defined as short date > as in the regional setting in the control panel - Windows), > it is behaving very > strangely. When I insert a date 01/06/2000 (dd/MM/yyyy > format), it stores the date > as 06/01/2000. On the other hand, when I try to insert > 20/06/2000, it stores it > correctly. > > Does any once faced this problem? > > Thanks in advance. > > >