The OFX standard is very complex but that should not be an excuse for some of the mistakes that sometimes happen.
It could be worse. I have one credit card that reverses the sign on charges and payments or the names of charges and payments, so everything comes in backwards. I will probably try switching to QIF for that one, but I vaguely recall there is a problem with that format too. I think even CSV has issues there. On Wed, Jan 12, 2022, 12:03 PM xraive . <xra...@hotmail.com> wrote: > I forgot to mention the file from RBC works fine. > > ________________________________ > From: xraive . <xra...@hotmail.com> > Sent: Wednesday, January 12, 2022 6:00 PM > To: Mattia Rizzolo <mat...@mapreri.org>; gnucash-user@gnucash.org < > gnucash-user@gnucash.org> > Subject: Re: [GNC] Transaction Date issues during import OFX file (TD Bank) > > Thanks for correcting me, I tried your suggestion and it came to the same > result. I've looked at my other financial institution and download their > transactions. They also have the same format the only difference being the > transaction time. > > TD: 20210722020000[-5:EST] > RBC: 20211025120000[-5:EST] > > ________________________________ > From: gnucash-user <gnucash-user-bounces+xraive=hotmail....@gnucash.org> > on behalf of Mattia Rizzolo <mat...@mapreri.org> > Sent: Wednesday, January 12, 2022 4:53 PM > To: gnucash-user@gnucash.org <gnucash-user@gnucash.org> > Subject: Re: [GNC] Transaction Date issues during import OFX file (TD Bank) > > On Wed, Jan 12, 2022 at 5:46 PM xraive . <xra...@hotmail.com> wrote: > > I changed [-5:EST] to [+2:EST] and the dates are working. But I don't > know why that would work. > > FWIW, +2:EST doesn't make sense. If you want UTC+2, that would be > +2:EET (for example). > > (though TBH I'm not sure what are the actual parsing rules (according > to the standard) of that datetime string, so it might or might not > change the result) > > -- > regards, > Mattia Rizzolo > > GPG Key: 66AE 2B4A FCCF 3F52 DA18 4D18 4B04 3FCD B944 4540 .''`. > more about me: https://mapreri.org : :' : > Launchpad user: https://launchpad.net/~mapreri `. `'` > Debian QA page: https://qa.debian.org/developer.php?login=mattia `- > _______________________________________________ > 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.
