Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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..

share|improve this question
Have you tried =INT(A1), where A1 is the cell with the combined Date-Time value? – user252816 Sep 10 '13 at 3:54

Having issues as well ( 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:

  • Select the cells with dates and hit Ctrl+H.
  • Use the search pattern (\d{4}-\d{2}-\d{2})T\d{2}:\d{2}:\d{2}\+\d{2}:\d{2}.
  • The replacement is $1.
  • Tick Regular expressions (click on More Options if you don't see it).
  • Click Replace All.
  • It should now recognize the dates (but you no longer have to format them anyway).
share|improve this answer
Thanks for your suggestion, but I have tried that without success! – Lars Öberg Sep 1 '13 at 9:21
Okay, just saw that I've got Calc installed in my virtual machine. Having a look - now I'm curious... :) – Mario Sep 1 '13 at 9:22
@Lars: It works exactly like Mario wrote (+1) – duDE Sep 1 '13 at 9:48
It's actually a workaround but I wouldn't consider it a direct answer, so wouldn't hurt to keep the question open for a bit longer. Maybe we're both missing something important. – Mario Sep 1 '13 at 16:22
@duDE: Let's wait for a day or to, as Mario suggested. That's wise. – Lars Öberg Sep 1 '13 at 16:39

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .