its very subtle but the formatting of the date from right aligned to left aligned is a dead give away that the format has changed from Date to text, thus making and attempt at determining all the records between date X and Date Y impossible.

Is there a way i can stop this so the format remains Date?