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

Hi all,

Found part of the problem its een North American vs European thing cmsb date is standard 2015-04-11  en european is 11-04-2015 (witch is more logic hahahah )

any one got a idea how i change 3000 dates in a winky?

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