From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp12.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms0.migadu.com with LMTPS id yIOKBlWbz2GAagEAgWs5BA (envelope-from ) for ; Sat, 01 Jan 2022 01:07:49 +0100 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp12.migadu.com with LMTPS id CEoZA1Wbz2FNrgAAauVa8A (envelope-from ) for ; Sat, 01 Jan 2022 01:07:49 +0100 Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id B3BDEAD1C for ; Sat, 1 Jan 2022 01:07:48 +0100 (CET) Received: from localhost ([::1]:33938 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1n3Rw3-0004p0-Fq for larch@yhetil.org; Fri, 31 Dec 2021 19:07:47 -0500 Received: from eggs.gnu.org ([209.51.188.92]:59556) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1n3Rv6-0004nm-AL for emacs-orgmode@gnu.org; Fri, 31 Dec 2021 19:06:48 -0500 Received: from [2607:f8b0:4864:20::42a] (port=38412 helo=mail-pf1-x42a.google.com) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1n3Rv4-0007R8-Is for emacs-orgmode@gnu.org; Fri, 31 Dec 2021 19:06:47 -0500 Received: by mail-pf1-x42a.google.com with SMTP id b22so24630046pfb.5 for ; Fri, 31 Dec 2021 16:06:46 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=references:user-agent:from:to:subject:date:in-reply-to:message-id :mime-version:content-transfer-encoding; bh=dR+XkIt3PDiAA/zKzrCoskMHnfKE0PRkerNcmnggM1I=; b=OPVj/neIeTrNUM0xFbk2m0QGSrNvWu7sIMqBO974firvKVeNRXYk9LTvZPEpfWLUbr 4wBq2FTDfP2jbSaxsLpJITs1W1gQ4ilOR2lzOoAnyOVDKvTsNv4jVqDQ2hsXHplGJ013 CIWVlqj1R7UpoFc3PBdPBtCOmp0Xm//F/XCu7Ni88ZgyWWkZ9JMnpWzBwQ41f5WeaI+0 V9z09Afoxrqn0z72JVk2xx8iBFntvP07ZBqRfIbJFP+flKR+L5mFY7loXbzUVx0r2z9r OSTYodXMDujkSo4FMua6X6vChYkt7Yu57Q2oELwbxfz8Ox+7+D8HjVJSKuv9ZIqjeU2Q XptA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:references:user-agent:from:to:subject:date :in-reply-to:message-id:mime-version:content-transfer-encoding; bh=dR+XkIt3PDiAA/zKzrCoskMHnfKE0PRkerNcmnggM1I=; b=nPf78w0qhILulWF7cECMc46UgM+2kLL+1orJpRH00Qykjd6tuVjm/puNZOynZ5im1a vBazpPVvmKJmlXq6AibSTRZoZ/BecY3bDBaOi93fQbZfu/XxBKZUaeMf46yWteWgtua6 AO0HLDXyY+VVHJZnl36G5PX6BZ/Y8p0UB/jA4MxIhBlQy6/WomnhTBUE3OklHRPGOpFo zkVeDMaais1gwfopyzAOj73I0/fkfRPqXYbnZUGyPrPodHmAcN/yqQ8xexHzSSWB/AEf I5KBys+iVh9wz/XwOFwEPDBuOiu1rm90jREsBLXS7iZUYXBfI6zShtmSD2Joz8096rs6 m4zQ== X-Gm-Message-State: AOAM531hTPIgvyqK5EdtLydkC5OtK5q86CPdhZDst8u/KfC2RTzwWBmJ EcNlQYnSJHgfDzxERe8Tl5XcWJ9OZxg= X-Google-Smtp-Source: ABdhPJxg1nx/A4jPe8iPhgryfMsze+90mXIpsPJG5d0rStyWDAsZNhpn0hdva4I7/UwZMZDz59yM+Q== X-Received: by 2002:a05:6a00:a28:b0:4bb:fdc0:7121 with SMTP id p40-20020a056a000a2800b004bbfdc07121mr23467445pfh.38.1640995604863; Fri, 31 Dec 2021 16:06:44 -0800 (PST) Received: from dingbat ([124.149.107.194]) by smtp.gmail.com with ESMTPSA id e20sm31702342pfv.219.2021.12.31.16.06.43 for (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 31 Dec 2021 16:06:44 -0800 (PST) References: <871r1tc0cm.fsf@mat.ucm.es> <87czld4lkw.fsf@gmail.com> <87o84xji42.fsf@mat.ucm.es> User-agent: mu4e 1.7.5; emacs 28.0.90 From: Tim Cross To: emacs-orgmode@gnu.org Subject: Re: org table problems with sorting of some column Date: Sat, 01 Jan 2022 11:05:12 +1100 In-reply-to: <87o84xji42.fsf@mat.ucm.es> Message-ID: <87pmpcs4j2.fsf@gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-Host-Lookup-Failed: Reverse DNS lookup failed for 2607:f8b0:4864:20::42a (failed) Received-SPF: pass client-ip=2607:f8b0:4864:20::42a; envelope-from=theophilusx@gmail.com; helo=mail-pf1-x42a.google.com X-Spam_score_int: 6 X-Spam_score: 0.6 X-Spam_bar: / X-Spam_report: (0.6 / 5.0 requ) DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RDNS_NONE=0.793, SPF_HELO_NONE=0.001, SPF_PASS=-0.001 autolearn=no autolearn_force=no X-Spam_action: no action X-BeenThere: emacs-orgmode@gnu.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+larch=yhetil.org@gnu.org Sender: "Emacs-orgmode" X-Migadu-Flow: FLOW_IN X-Migadu-Country: US ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1640995668; h=from:from:sender:sender:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc:mime-version:mime-version: content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references:list-id:list-help: list-unsubscribe:list-subscribe:list-post:dkim-signature; bh=dR+XkIt3PDiAA/zKzrCoskMHnfKE0PRkerNcmnggM1I=; b=TfQY8LUFwp+o6LNiRNDYlMzdq3FUZod1cfKK8zHDrV85Jzx9XcbbvCf0pvVHi2vx2cF8jp isb33lr09qf8NZyFWiNa884tHchl7TXrr4BwHsuKYGftO2i9hvqGs+0oQCGJhfc33TmpNC v/ktJJKNSajwXNEsTPiBi3/8H+kxLpFNIZXG7iWA8haVaVwBxD5ceGhQeSiPpabUBFRwHe 5HWrAnZY8AxiNNXZ9SUNvkLZLzUd635SuxI9ORHU07VwOOHEcnEPZLjEpUtjKWU8SzAdqd QMjdAXB3wcxv6emuGI/Z29CRBWg3XNQvx8Nrr5gsdjuWy3HeXM1JFtA1JNx8wQ== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1640995668; a=rsa-sha256; cv=none; b=naRCNoS9m7CBek/JTR/11qhxvszawCU8t8u64SOVRKQXPGPAae/Cwpjy2eEnNsrhAODqpS fE7FCg57FKTMXfGP2/X7//+QFevJaUusLJ65ehJV60MJDc8sHNzk7mPS3fT4dVG0lvxW7d YZfwTM/e8aAPbWcrAWIvsCFTA0w3aMFHdgCVK858xt1ov+7k9zSVDlOCfFM4e5p7KA7Y/2 7KdtpIE4WhGrXX9TEpptSNVSEL6E8f+BVUoJAPdC2BBc+YNpy4ZfV1remz1eNgZQhxZAia 7zfVxq3i3uHboB/lEpHPsczmtJWGBDFVur3UVFynbi/lf1+JFoXs0E31auKPLw== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=pass header.d=gmail.com header.s=20210112 header.b="OPVj/neI"; dmarc=pass (policy=none) header.from=gmail.com; spf=pass (aspmx1.migadu.com: domain of "emacs-orgmode-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="emacs-orgmode-bounces+larch=yhetil.org@gnu.org" X-Migadu-Spam-Score: -4.28 Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=gmail.com header.s=20210112 header.b="OPVj/neI"; dmarc=pass (policy=none) header.from=gmail.com; spf=pass (aspmx1.migadu.com: domain of "emacs-orgmode-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="emacs-orgmode-bounces+larch=yhetil.org@gnu.org" X-Migadu-Queue-Id: B3BDEAD1C X-Spam-Score: -4.28 X-Migadu-Scanner: scn1.migadu.com X-TUID: DhTmRGpf9+R/ Uwe Brauer writes: > [[S/MIME Signed Part:Undecided]] >>>> "TC" =3D=3D Tim Cross writes: > >> Uwe Brauer writes: > > >> For problem 1, I suspect you will need to either change the date format >> or tell org what the date format is. It won't work trying to sort >> numerically as those values are not really numerical values. The date >> format you currently have I think is ambiguous - in Europe it would >> represent dd-mm-yyyy, but in the US it would represent mm-dd-yyyy. Best >> solution would be to convert the values into an ISO format i.e. >> yyyy-mm-dd. > > I just checked=20 > I have the setting=20 > ,---- > | org-time-stamp-custom-formats is a variable defined in =E2=80=98org.el= =E2=80=99. > | Its value is (" %d.%m.%Y " . " %d.%m.%Y %a %H:%M ") > `---- > > But this as I understand only effect via=20 > =E2=80=98org-display-custom-times=E2=80=99 the representation.=20 > > It does not help me to recognise 28.04.2020 as a European date. > > [[End of S/MIME Signed Part]] I suspect org is actually passing off the sorting/comparison to calc (based on nothing but a guess of course). I would look into how calc determines the format for date/time calculations and see if that can help.