Nelson, the date format like 2017-05-25 is referred to in GnuCash as "ISO". I used the DD/MM/YYYY format for a long time. I developed an application that stored monthy files with the designation abcd0617.dbf for the abcd file for June 2017. During the second year of deployment I realized that those files would be sorted by the operating system by month and year with all of the June files together and all of the July files together but the years were not in order. It would have been convenient for me if they had been sorted chronologically. When I started work in the open source community Linux and MySQL utilized the 2017-05-25 format. I realized that format allowed alphabetical sorting used by the operating systems for sorting files by name would also sort those files chronologically. So now I name my backup files abcBU20170525112131.zip which is year month day hour minute second. They show up chronologically when sorted by name.
GnuCash backup files utilizes that naming convention for it's backup files. It is a good thing. Kind Regards, John Brown On Wed, Jun 21, 2017 at 5:57 PM, Nelson Handcock <[email protected]> wrote: > Hi, > > comparing your file to mine, I think you also have some information missing > that should be there... > > I think there should be a date_opened value (column 2). I guess it may be > set to the current system date if not provided, but I've never tried not > having it in my import files. > I'm intrigued by the date format you use - in my load files I use > "DD/MM/YYYY" - but again maybe that is dependent on your own GN settings > too > > Hope this helps... > > > Thanks & Regards, > > Nelson Handcock > 0409 149919 > > http://www.linkedin.com/in/nelsonhandcockaustralia > > On Thu, Jun 22, 2017 at 8:20 AM, Mike Evans <[email protected]> wrote: > > > Please file a bug report too. I just read the guide and the fact it > should > > be a string isn't mentioned there either. > > > > Mike E > > _______________________________________________ > > gnucash-user mailing list > > [email protected] > > 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 > [email protected] > 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 [email protected] 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.
