I've imported my records from Excel, and my layout includes a date field, which I thought was formatted as dd/mm/yyyy. I entered a new record with a date in this format, but noticed that the record did not sort into its correct place when sorted by date. I then noticed that clicking into the date field of any of the imported records displayed the date as the following example: "02/03/2012 12:00". How has the time element got into this field, and how can I get rid of it from all records? There are too many to retype individually).
Appreciate any advice.