facing issue in Date format while importing the csv file

divs
Kilo Contributor

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?

23 REPLIES 23

divs
Kilo Contributor

Hope these screenshots will help you.


can you send a screen shot of the actual field map you've configured for the date time field you're importing? Click on the record in the field maps tab and send a shot of what you've configured in there


payal8
Kilo Contributor

Hi Divya,



Open u_incident_occurred field and change the date format as given below,


find_real_file.png


In your CSV file date format is like 11/14/2016 11:30 ,it imported as,


find_real_file.png


Thanks,


Payal


divs
Kilo Contributor

Screenshot2.png


Hi Divya,



Change you date format field to dd/mm/yyy hh:mm as this is the format of the data you are importing. This field is telling the transform map what format your source data is in, it will convert it to your system set format when you run the import.