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
Importing csv vile
- Angeman
- Administrateur
- Posts: 2303
- Joined: 28 December 2008, 21:28
- Location: Toulouse, France
- Contact:
Re: Importing csv vile
Give me a sample date from your CSV file and I'll tell you the right date format to use.
-
- Posts: 3
- Joined: 10 November 2010, 14:10
Re: Importing csv vile
x
Last edited by lecycliste on 10 November 2010, 16:42, edited 1 time in total.
-
- Posts: 3
- Joined: 10 November 2010, 14:10
Re: Importing csv vile
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!!
all works now . I didn't understand I had to change the "/" into "."
Merci de votre aide!!