During our migration we had a lot of issues with date formats. The old system didn't save its date as a type and as such caused us all sorts of trouble. The key to getting the dates working was to apply a cryptic yet simple formula to the date values in Excel. The original Date Format was stored in Unix Epoch time. This is calculated as the ...