Re: Merging Quicken Files

Posted by Luis on April 12, 2006, 2:41 pm

Please log in for more thread options

wrote:

>Third, where did the qif file transaction in your post come

>from?

Quicken XG 2004 - the last UK version of Quicken.

>Are you in Canada?

No. I'm in deep dark Africa...

>As far as I know, qif file dates are

>always mm/dd/yy (or mm/dd/yyyy) - ignoring delimiters.

The qif file that I exported from Quicken XG 2004 UK is in the
dd/mm/yy format (eg. 14/10/99) as used in the UK and here in South
Africa.

>Fourth, qif file transaction dates should have a different

>delimiter for pre-year 2000 and post-year 1999 dates. For years

>1999 and earlier, the delimiter is "/", for post year 1999

>dates, the delimiter is "'". So "/ 1" is 1901 and "' 1" is

>2001.

They seem to be the same for pre and post 2000 dates in Quicken XG
2004 UK.

>[Newer versions of Quicken can read 4 digit years in qif files,

>which I believe can all use the forward slash for a delimiter

>for any year.]

I've tried changing 2 character year values to their 4 character
equivelants:

e.g.:
22/10/99
to
22/10/1999

and then importing that into Quicken. So far this seems to be giving
me much better results.