QIF import with two date format styles

Vista, 7, 8, 8.1. Unicode builds: x86, x64, ia64 versions available.

Moderator: Renato

Post Reply
wpdorr
New MMEX User
Posts: 1
Joined: Wed Jul 15, 2020 9:31 pm
Are you a spam bot?: No

QIF import with two date format styles

Post by wpdorr »

I am attempting to import a QIF file created by Microsoft Money. All dates prior to the year 2000 are in the format MM/DD/YYYY, and all dates after 2000 are formatted MM/DD'YYYY. Depending on which date format I choose in the MMEX import dialog, it will only import transactions that match the selected format, and does not import any records in the other format.
Nikolay
MMEX Developer
Posts: 1402
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: QIF import with two date format styles

Post by Nikolay »

mmex use only one date format at the same time.
I suggest to split your data to two blocks:
before the year 2000 and after.
Post Reply