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

[divs]

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 · Accepted solution]

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!

[Community Alums]

Hi divs - are you trying to load risks?

I faced the same issue and ended to create a specific transform map specific for dates to run after the data. Every time you load your data, you can select multiple transform maps and they will run one after another (the order is up to down - DESC).

Sample

Transform Map 1

• Add fields to work as identifiers (profile and statement for example) and mark "coalesce" to true on them
• Map all fields you want with the exception of dates..

Transform Map 2

• Add fields to work as identifiers (profile and statement for example) and mark "coalesce" to true on them
• Add all fields where type is date - make sure the Date Format is "dd/MM/yyyy". 

Let me know your thoughts. Having coalesced fields is quite important to keep uniqueness and do not create an additional record and update the existing ones instead.