All Transactions use today's (import) date instead of the transaction date

Bernard Caron's picture Submitted by Bernard Caron on

Issue summary: 

I am converting a Credit Card CSV file to QIF.  Everything comes out fine except the date which shows today  (the date when the conversion is done) instead of the day the transaction took place.

Component: 
Miscellaneous
Reporter: 
Bernard Caron
Created: 
Sun, 01/19/2020 - 23:05
Updated: 
Tue, 08/25/2020 - 00:24

Comments

Lenora Langman replied on

Was this resolved. I'm having same problem.  Is it related to the date format used in the original excel file?

Lenora Langman replied on

I was having this problem, too.  I was using dd/mm/yyyy format.   So, I changed by source data in Excel to m/d/yyyy, and of course then selected mm/dd/yyy in the converter, and now my dates are all loaded.

admin replied on

For this to work, it is necessary that the CSV contains the format specified. I have seen reports for this kind of issue but the CSV contained only Month and Day, the Year was missing. In that case the best thing to do is to open the CSV in Excel and add the Year, so the format matches what you selected

admin replied on

I converted the attached CSV and it worked

Mapped as:

  • Date YYYY/MM/DD
  • Ignore
  • Payee
  • Category
  • Amount
  • Ignore

Thre resulting QIF looks like this

!Type:Bank
D2020/01/07
T36.87
PFARM BOY #65
LGROCERY
^
D2020/01/07
T18.75
PPARK...
LTRAVEL
^
D2020/01/07
T9.92
PSUBWAY # 54091
LDINING