Importing Time / Date data

[sigmachiuta]

I am importing data from Excel.   The problem I am having is errors in the import log...I am looking in Excel and the format of the field is

2010-03-11 10:26:28

And in my transform map I have specified the date format seen below, so i am confused why i am receiving this error .   It looks like the date is correct but it is trying to format 03-11-2010 without time.   This is an excel sheet that i have reformatted to use yyy-MM-dd hh:mm:ss   Is Snow not recognizing the changed format?

com.glide.db.impex.transformer.TransformCoercionException: Unable to format 03-11-2010 using format string yyyy-MM-dd hh:mm:ss for field u_open_time

[jarodm]

This looks good, except you'll want `GlideDateTime` instead of `GlideDataTime`.

[Baggies]

I remember having a similar issue years ago, and think I ended up playing with the format in Excel, ie trying different formats on that column - first of all going through all the different time formats. I'll try an see if I have any old doc or emails on the subject.

[sigmachiuta]

So i am getting frustrated trying to get these dates loaded, i can believe it is this hard with an excel file.   I even tried to convert the .xls to a .csv and then import but i receive the error below.   I tried formatting the fields in excel to match what Snow is expecting.   I have tried converting the fields, adding a new field, and then changing the fields to text and then pasting from notepad.   All with no luck.

data contains 2 columns, expected 1

[Victor Ruiz]

Hi...did you ever get this to work?   I am having the same issue when importing (data contains #, expected #)

[Harish KM]

Hi Check this

Import Set - Date errors