Get the maximum date within a list of dates

Get the maximum date within a list of dates

[Truong Ha]

[-- Attachment #1: Type: text/plain, Size: 703 bytes --]

Hi,
How can I get the maximum date within rows of dates in the table?
|    Amount | Date             |+-----------+------------------+|       158 | <2013-12-01 Sun> ||       148 | <2013-12-02 Mon> ||       105 | <2013-12-03 Tue> ||       421 | <2013-12-08 Sun> ||        40 | <2013-12-10 Tue> ||       125 | <2013-12-11 Wed> ||        50 | <2013-12-12 Thu> ||        83 | <2013-12-13 Fri> ||       116 | <2013-12-14 Sat> ||        55 | <2013-12-15 Sun> ||        90 | <2013-12-16 Mon> ||       187 | <2013-12-17 Tue> ||        96 | <2013-12-18 Wed> ||        86 | <2013-12-19 Thu> ||        90 | <2013-12-20 Fri> ||       135 | <2013-12-21 Sat> ||        23 | <2013-12-22 Sun> |
Thanks,Ha 		 	   		  

[-- Attachment #2: Type: text/html, Size: 1654 bytes --]

Re: Get the maximum date within a list of dates

[Bastien]

Hi Truong,

Truong Ha <truonghatsts@outlook.com> writes:

> How can I get the maximum date within rows of dates in the table?
>
> |    Amount | Date             |
> +-----------+------------------+
> |       158 | <2013-12-01 Sun> |
> |       148 | <2013-12-02 Mon> |
> |       105 | <2013-12-03 Tue> |
> |       421 | <2013-12-08 Sun> |
> |        40 | <2013-12-10 Tue> |
> |       125 | <2013-12-11 Wed> |
> |        50 | <2013-12-12 Thu> |
> |        83 | <2013-12-13 Fri> |
> |       116 | <2013-12-14 Sat> |
> |        55 | <2013-12-15 Sun> |
> |        90 | <2013-12-16 Mon> |
> |       187 | <2013-12-17 Tue> |
> |        96 | <2013-12-18 Wed> |
> |        86 | <2013-12-19 Thu> |
> |        90 | <2013-12-20 Fri> |
> |       135 | <2013-12-21 Sat> |
> |        23 | <2013-12-22 Sun> |

Put your cursor in @2$2 then C-c ^ T to sort by "reversed" date
(oldest last).

HTH,

-- 
 Bastien

Re: Get the maximum date within a list of dates

[Bastien]

Bastien <bzg@gnu.org> 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

Re: Get the maximum date within a list of dates

[Ha Truong]

[-- Attachment #1: Type: text/plain, Size: 916 bytes --]

Thanks Bastien, it's what I am expecting :)

> From: bzg@gnu.org
> To: truonghatsts@outlook.com
> CC: emacs-orgmode@gnu.org
> Subject: Re: Get the maximum date within a list of dates
> Date: Sun, 22 Dec 2013 08:27:08 +0100
> 
> Bastien <bzg@gnu.org> 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
 		 	   		  

[-- Attachment #2: Type: text/html, Size: 1290 bytes --]