Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

Having issues as well (4.0.2.2 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
1  
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
1  
@duDE: Let's wait for a day or to, as Mario suggested. That's wise. –  Lars Öberg Sep 1 '13 at 16:39

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.