My question is datepart seems can't able to detect / differenticate which one is month and day. It got confuse. I have downloaded a few cool / great calendar javascript like from Tigra and it produces this date format (dd/mm/yyyy). But when I want to save it into my Mysql field (the datatype I use is date), it will get a little confuse, sometimes the mm will become dd and vice versa.

I wonder if any of you all face before the same problem. How do you fix this problem? Changed the date input format to become format like 1 May 2004 and then convert it into dd/mm/yyyy?

The way I use datepart is
rs("order_date") = DatePart("YYYY", strOrderDate) & "/" & Right("0" & DatePart("D", strOrderDate),2) & "/" & Right("0" & DatePart("M", strOrderDate),2)