[GNC] Date format for QIF file

[Peter West]

I did. My question remains. What are the formats? For example, is YYYY/MM/DD supported? What, exactly, does NN/NN/(NN)NN mean? In my corner of the world, NN/NN/(NN)NN is taken to mean DD/MM/(YY)YY. In the US, it means MM/DD/(YY)YY, apparently. It is surprising to me that an unambiguous QIF date spec like dd monthname year is not supported.
—
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 6:18 am, Dan Black <dblack2001 at outlook.com> wrote:
> 
> If you read Derek's reply again, he stated that you must use numbers only; month names are not acceptable.
> 
> Dan
> 
> On December 29, 2022 3:14:02 PM Peter West <pbw at pbw.id.au> wrote:
> 
>> 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.
>> 
>> _______________________________________________
>> 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.
> 
>