Example of the field is 27/01/2016 11:25:00 None of the fields have any second values. They're all 00. Within the file it's formatted as dd/mm/yyyy hh:mm. I've tried changing it to yyyy-mm-dd hh:mm:ss but when I do that, save and re-open it's reverted to the original format. I can upload into a text field (and it appears as 27/01/2016 11:25) but then if I cast the field as a timestamp it then returns null values.
... View more
