Helping my elderly mother-in-law with her bookkeeping.

Her bank is in a different country that uses date format DD-MM-YYYY.

I downloaded the csv from her bank and tried importing it to a spreadsheet.

The spreadsheet app does not understand that date format and doesn't treat it as a "date" column so it doesn't know how to sort the column by date.

I could adjust the data using Python csv module before importing to spreadsheet, but feels like it doesn't need to be this hard. ๐Ÿ˜ฉ

0

If you have a fediverse account, you can quote this note from your own instance. Search https://fosstodon.org/users/mariatta/statuses/115850380914364708 on your instance and quote it. (Note that quoting is not supported in Mastodon.)