The only way I could get auto sort in date to work properly was by formatting the cells as a text field and entering the numeric equivalent of a date, then reverting the format to dat..

eg
28/02/2014 = 41698