And do you live in the Eastern Standard Time zone?
On Tue, Jan 11, 2022, 4:49 PM xraive . <xra...@hotmail.com> wrote: > If I haven't mentioned it, I'm running GNUCASH Version: 4.9 Build ID: > 4.9+(2021-12-18) on a Windows 10 PC. The time settings on this PC are > correct as far as I can tell. > > Thanks in advance. > > ------------------------------ > *From:* xraive . <xra...@hotmail.com> > *Sent:* Tuesday, January 11, 2022 10:33 PM > *To:* David Carlson <david.carlson....@gmail.com>; Jean Laroche < > rip...@gmail.com> > *Cc:* gnucash-user@gnucash.org <gnucash-user@gnucash.org> > *Subject:* Re: [GNC] Transaction Date issues during import OFX file (TD > Bank) > > Sorry for the late response. I tried removing [-5:EST] and the issue > still persists. All the dates are still reported as one day earlier. I > imported the same file in MSMoney and the dates matched the banks if that > helps. > > Thanks for your assistance so far. > > *From:* gnucash-user <gnucash-user-bounces+xraive=hotmail....@gnucash.org> > on behalf of David Carlson <david.carlson....@gmail.com> > *Sent:* Tuesday, January 11, 2022 9:33 PM > *To:* Jean Laroche <rip...@gmail.com> > *Cc:* gnucash-user@gnucash.org <gnucash-user@gnucash.org> > *Subject:* Re: [GNC] Transaction Date issues during import OFX file (TD > Bank) > > That -5 EST relates local time to universal time and may come into play if > the local computer clock is not set to the local time zone. Usually it > clarifies the source time reference of the data. > > On Tue, Jan 11, 2022, 2:07 PM Jean Laroche <rip...@gmail.com> wrote: > > > > I wonder what happens if the "[-5:EST]" gets removed. The dates seem > to > > have 0200 as their time; subtracting 5 hours from that would return -3 > > o'clock (and presumably shift the date back one). > > > > You could do a test where you modify your OFX file to remove [-5:EST] > > from all transactions (you can do that easily in an editor), then try to > > import it and see whether this fixes the dates. > > > > After that the question is whether that [-5:EST] is valid or not. > > Jean > > > > > > On 1/11/22 11:59 AM, D. via gnucash-user wrote: > > > But EFT transactions (which are the bulk of my txns these days) > > shouldn't get shifted around much at all. I'd be miffed if every EFT > entry > > were a day off. > > > > > > > > > -------- Original Message -------- > > > From: Gyle McCollam <gmccol...@live.com> > > > Sent: Tue Jan 11 13:33:51 EST 2022 > > > To: "D." <sunfis...@yahoo.com> > > > Cc: "gnucash-user@gnucash.org" <gnucash-user@gnucash.org> > > > Subject: Re: Re: [GNC] Transaction Date issues during import OFX file > > (TD Bank) > > > > > > I find my dates usualy do not agree with the bank dates. I record > > credit card bills when I pay them (electronically) and they are recorded > by > > the payee on the same date. However, they usually hit my bank the next > > banking day. This isn't and shouldn't be a problem or concern. Actual > > physical checks take even longer to show up at the bank. This is all > > normal. > > > > > > > > > Thank You, > > > Gyle McCollam > > > > > > Gyle McCollam > > > > > > 609.680.2326 Mobile > > > > > > gmccol...@live.com<mailto:gmccol...@gyleshomes.com > <gmccol...@gyleshomes.com>> email > > > > > > ________________________________ > > > From: gnucash-user <gnucash-user-bounces+gylemc=gmail....@gnucash.org> > > on behalf of D. via gnucash-user <gnucash-user@gnucash.org> > > > Sent: Tuesday, January 11, 2022 1:20 PM > > > To: David Carlson <david.carlson....@gmail.com> > > > Cc: GnuCash <gnucash-user@gnucash.org> > > > Subject: Re: [GNC] Transaction Date issues during import OFX file (TD > > Bank) > > > > > > I'd be annoyed at the shift. > > > > > > I wonder what happens if the "[-5:EST]" gets removed. The dates seem > to > > have 0200 as their time; subtracting 5 hours from that would return -3 > > o'clock (and presumably shift the date back one). > > > > > > > > > -------- Original Message -------- > > > From: David Carlson <david.carlson....@gmail.com> > > > Sent: Tue Jan 11 12:53:59 EST 2022 > > > To: "xraive ." <xra...@hotmail.com> > > > Cc: Gnucash Users <gnucash-user@gnucash.org> > > > Subject: Re: [GNC] Transaction Date issues during import OFX file (TD > > Bank) > > > > > > Your bank creates the Ofx file. Gnucash just accepts what they give > > you. > > > Sometimes it may appear to be incorrect when it is a misunderstanding > > about > > > whether transactions are posted on the same day they occur. > > > > > > Does it really make a difference? > > > > > > > > > > > > > > > On Tue, Jan 11, 2022, 10:12 AM xraive . <xra...@hotmail.com> wrote: > > > > > >> I downloaded transactions from my bank (TD) in Canada and when I tried > > >> importing the file into GNUCASH all the dates were set to one day > > earlier > > >> then the actual transactions. I'm including sample transactions > below. > > >> > > >> OFX file imported to GNUCASH > > >> > > >> <STMTTRN> > > >> <TRNTYPE>DEBIT > > >> <DTPOSTED>20210722020000[-5:EST] > > >> <TRNAMT>-14.64 > > >> <FITID>21203175847980020 > > >> <NAME>Best Buy > > >> </STMTTRN> > > >> <STMTTRN> > > >> <TRNTYPE>CREDIT > > >> <DTPOSTED>20210726020000[-5:EST] > > >> <TRNAMT>21.83 > > >> <FITID>21207193333980010 > > >> <NAME>Home Depot > > >> </STMTTRN> > > >> > > >> Any help would be greatly appreciated. If you need additional > > information > > >> please let me know. > > >> > > >> Thanks > > >> _______________________________________________ > > >> 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. > > > _______________________________________________ > > > 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. > _______________________________________________ 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.