Date problem in database

Hi, I've got a problem with my database

I've got a couple of pages where you can insert dates into a database. Format: dd/mm/yyyy

Works great, if the day cannot be a month.

When I pick a day between the 1st and the 12th, the bigger number, whether it is the day, or the month, will become the month.

So 27/01/2004 will be inserted as 27/01/2004, but 03/02/2004 for instance, will be inserted as 02/03/2004

Even more strange, with these two dates, 03/02/2004 will be known as *before* 27/01/2004

I hope someone can help me with it.

At times I've had to disect the date from a known format then reassemble it again into a known format. Time is a bugger to work with as well, especially when you need a high degree of accuracy.

There was a question on something like this at sqlservercentral.com a couple weeks ago. It was about translating dates for a database that served UK and US offices.

Try setting your LCID explicitly. It might help out.

If you need some messy ugly horrible date processing code, let me know. I might have something that can help.

@ zaboss: If nothing else helps, I'll try that way, with the dropdowns. I'd prefer having it another way, but that might be the best solution.

@ Bluefrog: I've tried it with LCID. The problem is, it helps with getting the dates out of the database, but it's no good for inserting anything in it.
For the moment, when typing the date in the US-format in the administration panel, it goes into the database like that, and thanks to LCID, where users can see it, it shows in Belgian-format.

So, if anyone knows how I can make it so that I can insert anything in a format other than the host's default, it would be greatly apreciated.

I'll see if this can help me

But thanks for the help