From mboxrd@z Thu Jan  1 00:00:00 1970
From: Viktor Rosenfeld <listuser36@gmail.com>
Subject: date function in table formula does not understand German date
 stamps
Date: Wed, 31 Oct 2012 13:06:32 +0100
Message-ID: <20121031120631.GA2350@kenny.fritz.box>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([208.118.235.92]:52724)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <listuser36@gmail.com>) id 1TTX4B-0002gp-5x
	for emacs-orgmode@gnu.org; Wed, 31 Oct 2012 08:06:44 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <listuser36@gmail.com>) id 1TTX49-00025r-VW
	for emacs-orgmode@gnu.org; Wed, 31 Oct 2012 08:06:39 -0400
Received: from mail-bk0-f41.google.com ([209.85.214.41]:33667)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <listuser36@gmail.com>) id 1TTX49-0001yC-OR
	for emacs-orgmode@gnu.org; Wed, 31 Oct 2012 08:06:37 -0400
Received: by mail-bk0-f41.google.com with SMTP id jm1so629041bkc.0
	for <emacs-orgmode@gnu.org>; Wed, 31 Oct 2012 05:06:36 -0700 (PDT)
Content-Disposition: inline
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=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: emacs-orgmode@gnu.org

Hi,

I use the function `date' in a table formula to convert org date stamps to
integers for further processing. However, after switching Emacs to a German
locale, this no longer works. Consider the table below:

| Stamp            | date   |
|------------------+--------|
| [2012-10-31 Wed] | 734808 |
| [2012-10-31 Mi]  | #ERROR |
#+TBLFM: $2=date(<$1>)

Org mode generally works fine with the German version of the date stamp, i.e.,
it is picked up in the agenda and deadline warnings work as expected. However,
the `date' function in a table formula does not work. My Emacs inserts the
German version of the date stamp after I've added the following file as
`.MacOSX/environment.plist': 

    <?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
    <plist version="1.0">
    <dict>
      <key>LANG</key>
      <string>de_DE.UTF-8</string>
      <key>LC_ALL</key>
      <string>de_DE.UTF-8</string>
    </dict>
    </plist>

This was necessary to make Cocoa Emacs correctly process filenames with umlauts.

Any idea how the date function can be made locale-aware? Or is there another
alternative for this calculation?

Thanks,
Viktor