facing issue in Date format while importing the csv file

divs
Kilo Contributor

‎01-22-2018 06:18 AM

whenever i am changing the date format (customized) according to Glide date time (yyyy-mm-dd hh:mm:ss) in csv...it is not saving the format.How can i accomplish that?

0 Helpfuls
  • 2,660 Views
23 REPLIES 23

Dubz
Mega Sage

‎01-22-2018 06:22 AM

Hi Divya,



When you're importing a date/time field in an import set the format you set on the field map is the format the system expects to see from your source data, it will then automatically convert it to your system set date and time format


0 Helpfuls

Jaspal Singh
Mega Patron
Mega Patron

‎01-22-2018 06:22 AM

Hi Divya,



Make sure the Transform map created for date field mapped has the pattern that you are trying to import via CSV.


find_real_file.png


Preview file
47 KB

divs
Kilo Contributor
In response to Jaspal Singh

‎01-22-2018 11:15 PM

But my date format in csv file which i exported is 11/14/2016 11:30 .that format doesn't exist in ServiceNow. then how can i map?I want to bring the format as ServiceNow expects and But in CSV, how can we do customization for date format?


0 Helpfuls

Ashutosh Munot1
Kilo Patron
Kilo Patron
In response to divs

‎01-22-2018 11:43 PM

Hi DIvya,



Can you tell me when you import this csv, what is the type of field where this date is saved?



Thanks


0 Helpfuls