Page 1 of 1

Importing csv vile

Posted: 10 November 2010, 14:14
by lecycliste
Hello,

I am trying to import a semi-colon separated file.

My bank includes several date columns (value date, final date, search date etc) for each transaction.

I have configured the import to select the value date field , but when I import all the columns works as I have configured .... except every time, the date fields are today's date in every field. Any advice?

In fact, it doesn't matter what column in the file I configure to go in the "Date" field, it ends up importing the current date.

thanks

Re: Importing csv vile

Posted: 10 November 2010, 15:07
by Angeman
Give me a sample date from your CSV file and I'll tell you the right date format to use.

Re: Importing csv vile

Posted: 10 November 2010, 15:24
by lecycliste
x

Re: Importing csv vile

Posted: 10 November 2010, 15:30
by lecycliste
ok I had date set to dd/mm/YY and have changed it to exactly how the file does date: dd.mm.yyyy.

all works now . I didn't understand I had to change the "/" into "."

Merci de votre aide!!