When I try and insert a UK format date (mm/dd/yyyy) into a database using an "Insert Record" behaviour, the date format inserted into the database is US (mm/dd/yyyy). I know this is a problem with SQL handling all dates as US. How can I get around this. Trying to edit the MX SQL code in "Code View" produces errors on the page. Would it be easier to change the view page (which uses the "SELECT ..WHERE.." statement) to reformat the date back to dd/mm/yyyy before executing the query? Any help will be most welcome.