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

Date and Time


Hi Divya,



Then you have to convert it to system time zone and set it to that date time field.





Thanks


If time zone is not present then we have to convert it.



Thanks


payal8
Kilo Contributor

Hi Divya,



You can specify the format of your input date in your field mapping date Format field itself.


More help may be provided from: Coverting date in string format to date field format.



Thanks,


Payal


divs
Kilo Contributor

where i need to convert it to system time zone?i


Do you have any script so that i can convert?


because i wanted to convert 11/14/2016 11:30   into yyyy-mm-dd hh:mm:ss(glide date time)