Hi,
I got this problem, on my asp page I insert a date to the database (access XP), before I insert the date I response.write on the page and the date shows fine, after the date is in the database the month and the day are switched, for example, March 4th 2003 which represents as 04/03/2003 (israeli time format which shows correctly on the response.write) will switch to 03/04/03 in the database (April 3rd). If I enter dates that cannot be switched such as March 15, the date will show correctly also in the database.
Any ideas?
Thanks,
Eyal
I got this problem, on my asp page I insert a date to the database (access XP), before I insert the date I response.write on the page and the date shows fine, after the date is in the database the month and the day are switched, for example, March 4th 2003 which represents as 04/03/2003 (israeli time format which shows correctly on the response.write) will switch to 03/04/03 in the database (April 3rd). If I enter dates that cannot be switched such as March 15, the date will show correctly also in the database.
Any ideas?
Thanks,
Eyal
Tony