I take that back. I think it is right. I thought hard coded and
frodatum were supposed to match. Unfortunately, it looks like the
mailed mangles the formula line.
On 7/11/07, Eddward DeVilla <[EMAIL PROTECTED]> wrote:
Is this any better. I don't think it's entirely right yet.
|---+------------+------------+------------+------------|
| | datum | from datum | hard coded | |
|---+------------+------------+------------+------------|
| # | 2007-01-01 | 1 | 1 | 2007-01-01 |
| # | 2007-07-09 | 190 | 190 | 2007-07-09 |
| # | 2007-07-11 | 192 | 192 | 2007-07-11 |
| # | 2007-09-11 | 254 | 1 | 2007-09-11 |
| # | 20071012 | 192 | 1 | 20071012 |
|---+------------+------------+------------+------------|
#+TBLFM: $3='(time-to-day-in-year (org-read-date t t (concat
$2)))::$5='(concat $2)::@2$4='(time-to-day-in-year (org-read-date t t
"2007-01-01"));N::@3$4='(time-to-day-in-year (org-read-date t t
"2007-07-09"));N::@4$4='(time-to-day-in-year (org-read-date t t
"2007-07-11"));N::@5$4='(time-to-day-in-year (org-read-date t t
"2007-01-01"));N
On 7/11/07, Cecil Westerhof <[EMAIL PROTECTED]> wrote:
> I have the following table:
>
|---+------------+---------------------------+------------+------------------------------------------|
> | | datum | from datum | hard coded |
|
>
|---+------------+---------------------------+------------+------------------------------------------|
> | # | 2007-01-01 | 192 | 1 | [50, 48,
48, 55, 45, 48, 49, 45, 48, 49] |
> | # | 2007-07-09 | 192 | 190 | [50, 48,
48, 55, 45, 48, 55, 45, 48, 57] |
> | # | 2007-07-11 | 192 | 192 | [50, 48,
48, 55, 45, 48, 55, 45, 49, 49] |
> | # | 2007-09-11 | 192 | 1 | [50, 48,
48, 55, 45, 48, 57, 45, 49, 49] |
> | # | 20071012 | 192 | 1 | [50, 48,
48, 55, 49, 48, 49, 50] |
>
|---+------------+---------------------------+------------+------------------------------------------|
> #+TBLFM: $3='(time-to-day-in-year (org-read-date t t "$2"));N::$5="$2"::@2$4='(time-to-day-in-year
(org-read-date t t "2007-01-01"));N::@3$4='(time-to-day-in-year (org-read-date t t
"2007-07-09"));N::@4$4='(time-to-day-in-year (org-read-date t t "2007-07-11"));N::@5$4='(time-to-day-in-year
(org-read-date t t "2007-01-01"));N::
>
> The column 'from datum' does not get the right values. The last column
> shows why. "$2" gives a list of ASCII values of the string instead of
> the string. This makes that org-read-data gets 50 as a parameter instead
> of the string representing a date. How do I convert this list back to
> the string it is representing?
>
> --
> Cecil Westerhof <[EMAIL PROTECTED]>
>
>
>
> _______________________________________________
> Emacs-orgmode mailing list
> Emacs-orgmode@gnu.org
> http://lists.gnu.org/mailman/listinfo/emacs-orgmode
>
_______________________________________________
Emacs-orgmode mailing list
Emacs-orgmode@gnu.org
http://lists.gnu.org/mailman/listinfo/emacs-orgmode
