So I have a process which opens one Excel file and copies the data into a collection. One of the fields is a date, which appears to be imported in a DateTime format (DD/MM/YYY HH:MM:SS) but is stored as Text.
This process runs for many different rep...