When I export from MoneyWiz in CSV-files and open this CSV-files with Numbers, i have a problem with converting the date format from MpneyWiz in the a valid date format in Numbers. I need a valid date format in Numbers for sorting and filtering dates.
Platform: macOs sierra
Preferred Language: German (Switzerland)
Keboard Preferences: Swiss (German)
This problem does not appear when I set "Region" to "United Kingdom" (with "/" as date format separator). So I think an7930 addition of the export date formats in MoneyWiz with date formats with "." as the date format separator would solve this problem.
Thank you for your answer
Yes, I would like at least an additional export date format "DD.MM.YYYY" in MoneyWiz (my domestic date format), because indeed I cannot change the date format from "Automatic" to "Date" in Numbers as it is possible with system preferences "Region" = "United Kingdom" ("/" as date format).
Apart from this lack Numbers sorts in the exported data in the column "Date" first of all the digits before the first separator (/), then the digits after the first and before the second separator (/), finally the digits after the second separator (/). Thus the only MoneyWiz export date format who allows reasonable sorting the values in the column "Date" in Numbers as dates is "YYYY/MM/DD". But this way is rather strange and tedious for me, and beyond I cannot filter the data in Numbers in this way.
I sent you an answer yesterday, but I can't find anything here yet. So I repeat my answer.
Yes, I would like at least "DD.MM.YYYY" as an exporting date of MoneyWiz, because indeed I cannot change the exported date format with "/" as separator from "Automatic" to "Date" in Numbers (works with date formats with "/" as separator like the that of United Kingdom). As a poor alternative I could export from MoneyWiz with the date format "YYYY/MM/DD". Thereby reasonable sorting this unchanged date format in Numbers is possible, but not filtering. And the use of this date format is rather strange for me.
thank you for your answer.
What you suggest I can do with the "find & replace" function in TextEdit (standard opener of CSV file). I find and replace not exactly the dates with "/" as separators, but all "/", but for my purposes it doesn't matter. But both approaches are makeshifts for me.