Date format in qif?
Bill Gribble
grib@linuxdevel.com
07 Nov 2001 06:53:00 -0600
On Wed, 2001-11-07 at 01:53, stevechampeau@mindspring.com wrote:
> I am having trouble importing my qif file into gnucash 1.6.2 -
> it finds the date format ambiguous but gives no options in the date
> format dropdown box. I am thinking of writing a Perl script to change
> the dates into a less ambigous format. My question is : what is the least
> ambiguous format the dates can have in a qif file, if there is such a thing?
My guess is that the date format is inconsistent, not ambiguous, but for
some reason the importer's getting confused about it. Make sure all of
your dates are in the same format .. where format just means the
ordering of the date-parts (month, day, year). For added clarity you
can have the years completely written out (2001 instead of 01). If you
have the year completely written out and at least one transaction
occurring after the 12th of the month there's no way there can be
ambiguity.
b.g.