[GNC] Transaction Date issues during import OFX file (TD Bank)

[Mark Sutton]

The  [-5:EST] is in fact the problem. I think GNC posts in UTC.
They even change that when daylight saving time comes into effect. 
I either made the change in vi or wrong a sed script. 
I'll have a look at what I did.

On Tue, Jan 11, 2022 at 12:06:04PM -0800, Jean Laroche 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 <gmccollam at live.com>
> > Sent: Tue Jan 11 13:33:51 EST 2022
> > To: "D." <sunfish62 at yahoo.com>
> > Cc: "gnucash-user at gnucash.org" <gnucash-user at 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
> > 
> > gmccollam at live.com<mailto:gmccollam at gyleshomes.com>           email
> > 
> > ________________________________
> > From: gnucash-user <gnucash-user-bounces+gylemc=gmail.com at gnucash.org> on behalf of D. via gnucash-user <gnucash-user at gnucash.org>
> > Sent: Tuesday, January 11, 2022 1:20 PM
> > To: David Carlson <david.carlson.417 at gmail.com>
> > Cc: GnuCash <gnucash-user at 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.417 at gmail.com>
> > Sent: Tue Jan 11 12:53:59 EST 2022
> > To: "xraive ." <xraive at hotmail.com>
> > Cc: Gnucash Users <gnucash-user at 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 . <xraive at 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 at 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 at 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 at 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 at 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 at 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.