[GNC] Date format for QIF file

Dan Black dblack2001 at outlook.com
Thu Dec 29 15:18:39 EST 2022


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.



More information about the gnucash-user mailing list