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

[David Carlson]

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 . <xraive at hotmail.com> wrote:

> I forgot to mention the file from RBC works fine.
>
> ________________________________
> From: xraive . <xraive at hotmail.com>
> Sent: Wednesday, January 12, 2022 6:00 PM
> To: Mattia Rizzolo <mattia at mapreri.org>; gnucash-user at gnucash.org <
> gnucash-user at 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.com at gnucash.org>
> on behalf of Mattia Rizzolo <mattia at mapreri.org>
> Sent: Wednesday, January 12, 2022 4:53 PM
> To: gnucash-user at gnucash.org <gnucash-user at gnucash.org>
> Subject: Re: [GNC] Transaction Date issues during import OFX file (TD Bank)
>
> On Wed, Jan 12, 2022 at 5:46 PM xraive . <xraive at 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 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.
>