I have upgraded to the latest LO 6.3.3 but a date issue is persistent. I use base to generate queries from a database and then create .csv files with Calc to transfer these files to an accounting package. Unfortunately since upgrading to 64 bit my dates are no longer working properly whereas previously they were consistent. I have checked locale settings for both kubuntu and LO and these are correct, but for some weird reason LO gets the month and date mixed up. (Note this does not happen in Openoffice 4, however OOo Base is too volatile to be of use currently otherwise I would have merrily continued using Oo.) I compared OOo and LO settings and these are the same. (I’m not even going to go into the decimal format that is driving me insane in LO either) All I can think of is that some or other update went awry. I read previous queries, eg “Does your LibreOffice locale need a date acceptance pattern for incomplete date input?” but found no answers to my headache. I have tried changing some inputs but still not working.
My Locale settings are for EN_ZA,
My OS is Kubuntu 19.04,
Laptop is an Intel i7 3520 @ 2.9gHz with 16gb Ram
I generally use sqlite date format YYYY-MM-DD, however, LO swaps it around to YYYY-DD-MM. (base is linked to a sqlite3 db).