Background: I’m running Manager Desktop Edition 17.10.88 and my .manager file is in my google drive rather than in the Application Data directory (so I double click it to load it). I had previously changed my date format back in November, but the only way I could find to do that was to run Manager from the start menu without loading my .manager file; it wasn’t possible to change it while inside my file (I had previously posted a question about this). I have the date format set to DD/MM/YYYY.
Just now I imported a qif file from my bank. The date in the qif file is in the format DD/MM/YYYY. However Manager has interpreted it as MM/DD/YYYY, and the entry appears in red in my bank accounts screen.
Does anyone know why this has happened? I corrected it manually in the imported line, but it hasn’t happened before and I did import statements in December. It seems like a bug that has maybe been triggered by the rollover to the new year.
First, you should update. You are more than 100 versions out of date. An improvement affecting date interpretation of imported bank statements was introduced last month, but it was only announced as affecting .ofx files. Maybe it also affected others. I’m not sure. No one else has mentioned this. It will be informative to see if anyone else has this problem.
It is true that you cannot change preferences when working on a data file that was opened directly rather than from the main Businesses page of the program. That is intentional, to reinforce awareness that you are working on a remote file.
Thanks, I’ll update. I was a bit confused because in the release announcements in the forum the last notice is for 17.10.42, but there’s obviously newer versions than that. I couldn’t see any other announcements about releases and changelogs so I was hesitant to update. Is there somewhere I should be looking where changelogs or announcements are made?
Thanks muchly. I installed the latest version and it still seems to interpret the date the wrong way around when I import the statement.
I’ve tried switching my date format to MM/DD/YYYY but that didn’t help; the dates were shown correctly in MM/DD/YYYY format in my bank account but importing the new statement still resulted in the wrong date.
@lubos do you know if there is an issue here? I can provide my .qif if that helps.
With regard to importing a QIF file when updating your bank accounts. I found that if there is only one transaction in the QIF file the date format for that transaction will import as mm/dd/yyyy even though the date format dd/mm/yyyy in the QIF file is correctly downloaded from the bank.
See example QIF content below for the 04 January 2018.
So my findings indicate that when importing a QIF file downloaded from the bank you ought to have at least two transactions in the QIF file to circumvent the date issue.
(I tested this import process on different Manager Bank accounts as you can see in this example and arrived at the same outcome for both the Trading Acc and the Credit Card account).