In LibreOffice, Calc under Linux, I have a table with DateTime values (eg. 2011-06-15T15:37:56+00:00). How shall I convert these values to just Date values (eg. 2011-06-15)? I suspect it is very simple..
Having issues as well (220.127.116.11 with English (US) locale): It somehow won't recognize the long ISO format for dates; only if I edit the date and remove the time. I've read about date acceptance patterns, but couldn't get them to work (why wouldn't it work by default to begin with?).
As a workaround (note: data will be lost!) you could use search and replace: