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