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 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/