[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [O] Get the maximum date within a list of dates
From: |
Bastien |
Subject: |
Re: [O] Get the maximum date within a list of dates |
Date: |
Sun, 22 Dec 2013 08:27:08 +0100 |
User-agent: |
Gnus/5.13 (Gnus v5.13) Emacs/24.3.50 (gnu/linux) |
Bastien <address@hidden> 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