Page 1 of 1

Date not importing

Posted: 17 September 2010, 11:35
by JonathanFokker
Hello,

Made a update to Icompta 4.0.6 but there is a something wrong.

Tried to import transactions, just as I do normally, but he doesn't import the date correctly. He imports all the transactions with the date today.
This are my settings:
Mac OS Roman
MM/dd/yy

Please help.
Jonathan

Re: Date not importing

Posted: 18 September 2010, 00:11
by Angeman
Can you post an extract of your file ? I'll tell you the date format to use.

Re: Date not importing

Posted: 19 September 2010, 17:57
by JonathanFokker
Here is one line of the CSV file:

"0139242120","EUR",20100831,"D",-44.55,"0285094785","GEM HOUTEN, BELASTINGEN",20100831,"ma","","BETALINGSKENM. 0041022500283988","GEMEENTELIJKE BELASTINGEN","TERMIJN 6 VERVALDAT. 31-08-2010","","",""

The bold digit of numbers are the date. I thought: yyyy/MM/dd?

Shalom,
Jonathan

Re: Date not importing

Posted: 19 September 2010, 18:03
by Angeman
You should use yyyyMMdd.

Re: Date not importing

Posted: 19 September 2010, 19:56
by JonathanFokker
Thanks. That did the trick.