Hello

I'm doing an Insert into a Access Database. One of the field is a Date field. Whenever I do the insert for the date for example: 09/10/2003 the date are entered as follows: 10/09/2003.

For some reason the the day and month are switched around. How can I fix this?

Thanks

Hi,

You Have Set , In The Control Panel-> Regional Options, The Date Format. Check It.

Greetings From Chile

Hi there,

Try enclosing your date between ## (i.e #01/09/04#)