csvImport dates error

Mon, 08 Jun 2015 12:34:51 -0700

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 :)

csvImport dates error

Mon, 08 Jun 2015 11:10:54 -0700

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

csvImport dates error

Mon, 08 Jun 2015 08:24:48 -0700

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

csvImport dates error

Mon, 08 Jun 2015 07:54:28 -0700

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

csvImport dates error

Mon, 08 Jun 2015 05:04:10 -0700

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