Page 1 of 1
Incorrect transaction date when importing
Posted: 22 October 2023, 21:55
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.
Re: Incorrect transaction date when importing
Posted: 23 October 2023, 10:02
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 ?
Re: Incorrect transaction date when importing
Posted: 24 October 2023, 03:25
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.