Date Format Dd/mm/yyyy

I have a form in which I query an access db, in this form I have a date selection input box. The format of the date in this function is dd/mm/yyyy. The format of the date in the access db is also dd/mm/yyyy. This is where I am having a problem. When submit this form with the current date it returns no values, although there are values in db. eg. submit form with 05/01/2005 no results. submit form with 01/05/2005 then the results are returned. Problem the latter format is mm/dd/yyyy and not dd/mm/yyyy.

How can fix this. I have a function that I have used previously to format dates, but this would not be viable in this program as it includes to many pages any this would affect all of them.

Below is the code for the page I am having trouble with: ...