This content has been marked as final. Show 7 replies
I have noticed when importing Excel files that there are some issues with date and time formats. With the newer type of file .xlsx (excel 2010 and so on) there seem to be intermittently correct date and time import i.e. some date and time columns have the correct format and others are reverted to the MS time code instead. This is an issue that should be looked into I think, it is supposed to be a simple import right? No extra scripting should be needed :-)
I have made my own remedy to that and i simply save my file in the sligthly older format .xls (Excel 97 - 2003). Then all dates and times are formatted correclty. No script changes needed. Just a small tip. However I really think I shouldn't need to use even this simple workaround.