I am creating a search page to search for entries between 2 dates already entered in the database.
The date in access is UK format (dd/mm/yyyy) and i am using 2 drop menus to pick the dates from which show correctly.
When i submit the form there are no records.
I tested the query and it works if i search using the US format (mm/dd/yyyy).
How can i get the drop down menus to post the data as US Format rather than UK so it will pick up the records from Access?
<select name="StartDate" id="select2">
While (NOT rsDate.EOF)
If (rsDate.CursorType > 0) Then