Incorrect transaction date when importing

Discussions about iCompta on macOS
Post Reply
placebo
Posts: 10
Joined: 26 November 2018, 07:31

Incorrect transaction date when importing

Post by placebo »

I seem to have run across a problem importing transactions. I downloaded the transactions from Vanguard in CSV format. The dates in the file are correct, but when I import the file into iCompta, all of the transactions appear with today's date.

I'm running Sonoma and using the latest version of iCompta from the App Store.
User avatar
Angeman
Administrateur
Posts: 2303
Joined: 28 December 2008, 21:28
Location: Toulouse, France
Contact:

Re: Incorrect transaction date when importing

Post by Angeman »

You need to adjust the date format setting in the import settings screen according to how the dates are written inside the CSV file. Can you open you CSV file with a text editor and copy/paste one sample date from the file ?
placebo
Posts: 10
Joined: 26 November 2018, 07:31

Re: Incorrect transaction date when importing

Post by placebo »

You nailed it. When I first ran across the problem, I did exactly what you suggested and opened the file in a text editor to check the date format. I then totally brain-farted and decided a date like 2022-11-01 was mm/dd/yyyy format. Sorry for wasting your time.
Post Reply