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

[David Carlson]

Derek is a developer.   Follow his advice

On Wed, Jan 12, 2022, 2:56 PM David Carlson <david.carlson.417 at gmail.com>
wrote:

> You as a user have no way of knowing the history that the developers have
> already done on that problem.   I would hope  that one of them will look at
> it and get back to us with an answer whether the solution committed last
> year didn't work,  never made it to release 4.9,  or what happened.
>
>
>
> On Wed, Jan 12, 2022, 2:41 PM xraive . <xraive at hotmail.com> wrote:
>
>> I've never filled out a bug report.  Can anyone confirm if need to submit
>> one or are the developers aware of this issue.
>>
>> ------------------------------
>> *From:* David Carlson <david.carlson.417 at gmail.com>
>> *Sent:* Wednesday, January 12, 2022 8:25 PM
>> *To:* xraive . <xraive at hotmail.com>
>> *Cc:* Mattia Rizzolo <mattia at mapreri.org>; Gnucash Users <
>> gnucash-user at gnucash.org>
>> *Subject:* Re: [GNC] Transaction Date issues during import OFX file (TD
>> Bank)
>>
>> 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.
>>
>>