From mboxrd@z Thu Jan 1 00:00:00 1970 From: Bastien Subject: Re: Get the maximum date within a list of dates Date: Sun, 22 Dec 2013 08:27:08 +0100 Message-ID: <87iouh9whf.fsf@bzg.ath.cx> References: <8738llbc9i.fsf@bzg.ath.cx> Mime-Version: 1.0 Content-Type: text/plain Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:40463) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1VudRW-0005yC-N3 for emacs-orgmode@gnu.org; Sun, 22 Dec 2013 02:27:24 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1VudRR-00013E-Ba for emacs-orgmode@gnu.org; Sun, 22 Dec 2013 02:27:18 -0500 Received: from mail-wg0-x22d.google.com ([2a00:1450:400c:c00::22d]:48044) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1VudRR-00012J-4T for emacs-orgmode@gnu.org; Sun, 22 Dec 2013 02:27:13 -0500 Received: by mail-wg0-f45.google.com with SMTP id y10so3879628wgg.0 for ; Sat, 21 Dec 2013 23:27:12 -0800 (PST) In-Reply-To: <8738llbc9i.fsf@bzg.ath.cx> (Bastien's message of "Sun, 22 Dec 2013 08:00:57 +0100") List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: Truong Ha Cc: "emacs-orgmode@gnu.org" Bastien writes: > Put your cursor in @2$2 then C-c ^ T to sort by "reversed" date > (oldest last). Also remember you can use ELisp in formulas: | Date 1 | Date 2 | Duration | |-------------------------+-------------------------+----------| | [2013-12-21 sam. 00:00] | [2013-12-22 dim. 00:00] | 86400.0 | #+TBLFM: $3='(- (org-time-string-to-seconds "$2") (org-time-string-to-seconds "$1"));L PS: note the quotes around "$2" and "$1", they are necessary so that the date is not literally inserted in the formulas when Org is computing it. HTH, -- Bastien