issue in importing the date format through excel/csv in Service now?

divs · ‎01-11-2018

Hi All,

i am facing the issue while importing the date type data in to service now.it is giving me error.

Please help me to rsolve this issue.can we write any script to bring it into yyyy-mm-dd format?

Dan51 · ‎10-25-2019

I had a similar issue, I thought my problem was coming from the excel sheet but it wasn't. Check your staging table. My data was going into the staging table as expected but then there was miscommunication from the staging table to my actual table. Hope this helps for debugging!

View solution in original post

Vijay Talupula · ‎01-12-2018

Hi Divya,

I don't think you need to go for scripting. Please refer to the below sample screenshot, where you can set your desired format in the Transform Map form under "Fields Map" section.

If you don't see this "date format" field, please configure the list layout to see and also follow the same for form if needed.

Dubz · ‎01-12-2018

Hi Divya,

Just to expand a little on what Vijay has said:

The date format field tells the import set what date format to expect from the source data, it will then transform the data into the format expected by your target field.

So, if your source is dd/mm/yyyy you should set the date format field to that, it will then transform the data to your system setting of yyyy-mm-dd.

avanigadda · ‎05-09-2018

i tried this but it still not working

i am importing this:

Getting below error:

Unable to format 2/4/17 using format string MM-dd-yyyy for field u_when_needed.

Please help me to fix this.

linnbuchanan · ‎05-18-2018

This doesn't help in fixing it within ServiceNow, but could you format the data (in excel) prior to importing it?