AnsweredAssumed Answered

Newbie question on date field

Question asked by eaststander on Mar 2, 2012
Latest reply on Mar 3, 2012 by comment

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.

 

Steve

Outcomes