Thank you for the prompt response. A clarification please, what does "AFAIK" stand for and I also use Libre Office these days, after using Open Office and Quattro Pro for years, never did use Excel.
Thank You, Gyle McCollam Gyle McCollam 609.680.2326 Mobile gmccol...@live.com<mailto:gmccol...@gyleshomes.com> email ________________________________ From: gnucash-user <gnucash-user-bounces+gylemc=gmail....@gnucash.org> on behalf of davidcousen...@gmail.com <davidcousen...@gmail.com> Sent: Tuesday, January 4, 2022 8:53 PM To: gnucash-user@gnucash.org <gnucash-user@gnucash.org> Subject: Re: [GNC] Import csv, ofx Gyle, Export it as Excel, load it up in Excel and export it from there as CSV. GnuCash has always read Excel's CSV exports AFAIK (I use Libre Ofiice these days and it certainly works with LO). You should also be able to set the date format in the CSV import dialog. It will likely default to the format specified for your locale but you can override that and store the format settings for future use. David Cousens On Wed, 2022-01-05 at 01:01 +0000, Gyle McCollam wrote: > I have been having a great experience importing ofx files for my bank accounts > and credit cards. However, when I tried to export from Discover Card, the > only options were Excel or csv. I didn't see that Gnucash imported Excel so I > used csv. I had absolutely no luck importing the csv file into Gnucash. I > kept getting an error message that the date was out of range (1-31). The date > format used by Discover is MM/DD/YYYY. Is the date range the import function > uses in a different format, therefore causing my issue? > > > Thank You, > Gyle McCollam > > Gyle McCollam > > 609.680.2326 Mobile > > gmccol...@live.com<mailto:gmccol...@gyleshomes.com> email > _______________________________________________ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > ----- > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
