Date not importing

Discussions about iCompta on macOS
Post Reply
JonathanFokker
Posts: 3
Joined: 17 September 2010, 11:31

Date not importing

Post 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
User avatar
Angeman
Administrateur
Posts: 2303
Joined: 28 December 2008, 21:28
Location: Toulouse, France
Contact:

Re: Date not importing

Post by Angeman »

Can you post an extract of your file ? I'll tell you the date format to use.
JonathanFokker
Posts: 3
Joined: 17 September 2010, 11:31

Re: Date not importing

Post 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
User avatar
Angeman
Administrateur
Posts: 2303
Joined: 28 December 2008, 21:28
Location: Toulouse, France
Contact:

Re: Date not importing

Post by Angeman »

You should use yyyyMMdd.
JonathanFokker
Posts: 3
Joined: 17 September 2010, 11:31

Re: Date not importing

Post by JonathanFokker »

Thanks. That did the trick.
Post Reply