[GNC] Date format for QIF file

ml at tgr66.me ml at tgr66.me
Thu Dec 29 13:57:59 EST 2022


Thank you Derek,

I understood *why* it was happening, and I do realize that in reality, as the file size grows, the chance of having all days <= 12 is pretty darn slim :-)

I appreciate the quick response.

Tim

> On Dec 29, 2022, at 12:55, Derek Atkins <derek at ihtfp.com> wrote:
> 
> Not particularly. 
> The issue is that 11/12 is ambiguous.  Is it November 12 or December 11?  Using a 2-digit year doesn't help. 
> The best way is to ensure you have a day > 12 in the mix (and a year > 31).  So using 12/29/2022 should give you a unique format. 
> You cannot use month names, only numbers. 
> -derek
> Sent using my mobile device. Please excuse any typos.
> 
> On December 29, 2022 14:35:09 ml at tgr66.me wrote:
> 
>> I’m developing QIF files to import my old investments. I get asked every time to confirm the date format (the entire import process is a bit long imo). The QIF specification says I ought to be able to enter a date using `dd month year`; for example: 29 December 2022. However, this results in an error in GnuCash.
>> 
>> Is there a format I can use in the files that GnuCash will accurately autodetect the correct format?
>> 
>> Thanks.
>> 
>> Tim
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -----
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
> 
> 



More information about the gnucash-user mailing list