Date/Time fields in Excel

Brian Element

Forums

Sometimes in Excel (and other databases) you will come across a field that contains both the date and time information such as: 2014-05-05  12:00:00 PM

If you bring in this field using the regular Excel import you will only capture the date portion of the field and the time portion gets dropped.

I was reading something on the IDEA forum and decided to try import using ODBC drivers for Excel, so I imported the same file and what happens is that in IDEA you will have now have two fields, one containing the date info and the other containing the time info.  So it seems if you have this type of problem you should be importing the file using the ODBC option and not the Excel option.

So does anyone else ever performed imports like this and have seen differences?

yinondotan Sun, 08/26/2018 - 09:05

Hi Brian
I had the same problem recently .The solution I found was to save the excel file as .csv and after import to idea of the date time fields as text, to define two virtual fields one date and one time.