RE: [PHP] Access Date question!!!

Check you're locale-settings: a year only has 12 months, so when you insert '20/06/2000' it will be seen by access as 'june 20th 2000', while '1/6/2000' will be seen as january 6th 2000...... If you want to insert a date in format dd/mm/yyyy you have to select a apropriate locale (for example: dutch) regards, Tim -----Oorspronkelijk bericht----- Van: Web Master [SMTP:webmaster@unni.com] Verzonden: donderdag 30 november 2000 16:59 Aan: php-general@lists.php.net Onderwerp: [PHP] 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. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net