I have imported a data from excel in access.
One of the column is 'DOJ' (date of joining).
After importing this data, DOJ was reflecting as number.
Hence I go to Design view and change DOJ formatting to Date/Time.
However, post this, some the records are reflecting as '07/12/2017...