Using the Import Wizard I have created an import .tim file which imports data held in a SharePoint List.
However I have noticed that the imported dates are different (one day earlier) than shown within SharePoint.
Example when viewing the dates in the List via SharePoint it is displayed as 04/04/2013 00:00:00, but when imported in to a TDP table using the .tim the imported date is 03/04/2013 23:00:00.
Upon further investigation it look like the dates are being imported with one hour difference and therefore shown as the day before.
Any idea why this is happening and what i need to do so I can correctly import these dates?
Thank you in advance.