Hi!
I tried to import the CSV file from my bank but run into the following problem - dates in the file are represented in DD.MM.YYY format, but CSV import seems not supporting such (there are 3 variations of D[space]M[space]Y only).

How would it be possible to import csv with dates in DD.MM.YYYY format?

d m y is what you want. Works perfectly for me with dates of the same format (DD.MM.YYYY) for years (which I get from my bank). What exactly is the problem? Any message? Which version of KMyMoney? I have 5.0.7 (plus the latest changes from git)

hmm.. indeed... I failed in my previous attempt for, as now seems, no obvious reason.
One problem still exists - my bank does not identify incoming and outgoing payments with signed numbers, but rather uses C(redit) and D(ebit) types in additional field.
I could "filter " it through python, but it is an additional step outside of KMymoney.

KMyMoney supports that. On the wizard page where you select the columns change from Amount to Debit/Credit and select the two columns.

I just recently discovered KMyMoney and was intrigued by the CSV importing functionality because my house bank does not offer another way of exporting data.

Unfortunately, when I try to import my statements, I get an error on the date field. The date is in the format DD/MM/YYYY.

Probably important: I am using the MacOS Version of KMyMoney and I have version 5.1.2-64335bc5d installed.

Is anybody able to help me with this?

racingdodo wrote:Unfortunately, when I try to import my statements, I get an error on the date field. The date is in the format DD/MM/YYYY.

Is anybody able to help me with this?

Sure, can you show a screenshot of the CSV file, e.g. first two lines, with the sensitive data masked, and the screenshot of the CSV importer dialog and your column/date settings?

On the formats page select "d m y" as the Date format and the background of the date column should turn green (tested on the Linux version, but that should not make a difference, IIRC)