It is possible to have different date formats in your spreadsheet or editing application than you use generally for your PC. That may have been the source of the problem.
These settings:
PC System DD/MM/YYYY
Excel sheet DD/MM/YYYY
Manager DD/MM/YYY
Produce this result on batch import:
Dates with DD <= 12 are interpreted as the month. For example date 05/10/2020 becomes 10/05/2020 on import. The format remains as DD/MM/YYYY but the month and the date are transposed.
If I change the format in excel sheet to MM/DD/YYYY then the batch import does not transpose the month and the date.
So it appears that Manager is not referencing any of the set formats and is interpreting the raw numbers in relation to the USA standard format of MM/DD/YYYY unless the date is not possible.
This has only been happening recently (in the last four weeks or so)
1 Like
@AJD you are right. It is actually the same issue I had. Only the postings with a day up to 12 were changed as Manager interpreted the first number as the month. And like you, Manager, PC and Excel are set to the DD/MM/YYYY.
If you use YYYY-MM-DD this issue can’t happen. Is it possible to change your preferences?
He is saying that Manager understand, under Batch operations, only dates that are in format YYYY-MM-DD indipendently from your Preferences. So you should change your format under Excel.
Also notice that under some Tab, for example under Bank Reconciliations, there is an issue also for amounts since Manager understand only decimal separator with dot and not comma.
Last keep in mind that, independently from your preference and this recent bug that hopefully @lubos will solve soon, for custom fields the standard formats be are YYYY-MM-DD and ##.00
The issue with the coma vs. dot happened also with my Batch Update. When I did it, not only the dates got changed, but also the figures, as I mentioned in my initial post.
Indeed, based on all the replies, it seems there is a bug.