Importing Date Fields from Excel to ServiceNow Via Transform Map

[jmiskey]

I have an Excel file of about 1300 records and 22 fields, 4 of which are Date fields.  I am trying to import them into a Custom table we have in ServiceNow, and am having problems with the date fields.  It is wildly inconsistent.  One field imports just fine, another imports with the wrong century (i.e. year 1905 instead of 2005), and another won't import at all!  The funny thing is, in ServiceNow, they are all Date fields, and in Excel, they are all set-up the same, so they should all behave consistently.

I have tried using the default "yyyy-MM-dd HH:mm:ss" format on my Transform map.  I have also tried "yyyy-MM-dd" and "MM/dd/yyyy".  None of them worked for all fields.  In Excel, I have tried importing them looking EXACTLY the same as the format on the Transform map.  I have tried having the dates entered as date win Excel, with the desired format.  I have also tried making them text entries instead, in the same expected structure.  I cannot get anything to work!!!

Is there any sort of "best practice" for importing date fields to a ServiceNow table from an Excel file via a Transform map?  I am a wiz with Excel, so I can put the Excel file fields it in ANY format that ServiceNow wants.  I just cannot seem to find one that it likes.  I just need to know what it wants!

Thanks

[AMULOZUC]

Actually I faced the same issue recently after long hours exploring I found out that changing the format of date in excel is helpful. I have changed my data field value in excel by " TEXT(column_name,"yyyy-MM-dd HH:mm:ss") " , then copied the column rows and pasted the values in desired date column. It worked for me.