csvImport dates error

5 posts by 2 authors in: Forums > CMS Builder: Plugins & Add-ons
Last Post: June 8, 2015   (RSS)

By Maurice - June 8, 2015

Hi IT team,

With de csv import i,m trying to import dates to a date field.

this is the date i'm importing  07-11-15 0:00  and this is what i get my section 15th Nov, 2007 its turning de numbers arround.

how can i fix this?

Greets Maurice

-------------------------------------------

Dropmonkey.nl

By Maurice - June 8, 2015

this is mind bottling pffffffffffffffffffffffffffffff

02-07-15 0:00 this date stamp is shown in excel and this 02-07-2015  12:00:00 AM whan wanting to change the date in excel

and this is shown when opening the csv file in notepad++    2015-06-03 10:19:48 

WTF???????????????????????????????

helppppppppppppppppp

-------------------------------------------

Dropmonkey.nl

By Maurice - June 8, 2015

Got it !!!!!!!!!!!!!!

took me a day but finaly it was easy done within  Excel change the cels specs to a custom date.  yy-mm-dd en thats it ahahahahah

Thnx

-------------------------------------------

Dropmonkey.nl

By claire - June 8, 2015

Hi Maurice, sorry I didn't get to this sooner! Yeah Excel is a bit of a bugbear when it comes to date formatting. Glad you got it sorted :)

--------------------

Claire Ryan
interactivetools.com

Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/