The supported formats are, IIRC: y-m-d y-d-m d-m-y m-d-y Every time you start an import it will begin with the full list and use the dates in the file to rule out from the list; if there remains more than one once all the file is loaded, then it asks you. If the set is empty once the file is loaded, then it raises an error.
-derek On Thu, December 29, 2022 3:30 pm, Peter West wrote: > 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 > p...@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 <dblack2...@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 <p...@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 >>> p...@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 <de...@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 m...@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@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@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@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. >> >> > > -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant _______________________________________________ gnucash-user mailing list gnucash-user@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.