[GNC] Date format for QIF file

[Peter West]

What date formats ARE supported by the GNC QIF import process? 29 December 2022 is unambiguous, but apparently unsupported by GNC.

Happy 6th day of Christmas!

—
Peter West
pbw at pbw.id.au
And the angel said to them, “Fear not, for behold, I bring you good news of great joy that will be for all the people. For unto you is born this day in the city of David a Saviour, who is Christ the Lord. And this will be a sign for you: you will find a baby wrapped in swaddling cloths and lying in a manger.”

> On 30 Dec 2022, at 4:55 am, 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.
> 
> _______________________________________________
> 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.