On Thu, 24 Mar 2022 20:56:45 +0000, Charles Ellson
<charlesellson@btinternet.com> wrote:

>On Thu, 24 Mar 2022 18:59:52 +0000, Scott
><newsgroups@gefion.myzen.co.uk> wrote:
>
>>On Thu, 24 Mar 2022 14:48:30 +0000,
>>martin.coffee@round-midnight.org.uk wrote:
>>
>>>On 24/03/2022 14:18, Scott wrote:
>>>> On Fri, 20 Nov 2020 06:46:09 +0000, Roland Perry <roland@perry.co.uk>
>>>> wrote:
>>>>
>>>>> In message <rp6780$uss$1@dont-email.me>, at 16:41:36 on Thu, 19 Nov
>>>>> 2020, Recliner <recliner.usenet@gmail.com> remarked:
>>>>>> Roland Perry <roland@perry.co.uk> wrote:
>>>>>>> In message <rp5ils$f4r$2@dont-email.me>, at 10:50:36 on Thu, 19 Nov
>>>>>>> 2020, Recliner <recliner.usenet@gmail.com> remarked:
>>>>>>>> Roland Perry <roland@perry.co.uk> wrote:
>>>>>>>>> In message <rp5fb8$p1a$2@dont-email.me>, at 09:53:44 on Thu, 19 Nov
>>>>>>>>> 2020, Recliner <recliner.usenet@gmail.com> remarked:
>>>>>>>>>> Roland Perry <roland@perry.co.uk> wrote:
>>>>>>>>>>> In message <rp3kln$f87$1@dont-email.me>, at 17:12:23 on Wed, 18 Nov
>>>>>>>>>>> 2020, Recliner <recliner.usenet@gmail.com> remarked:
>>>>>>>>>>>> Roland Perry <roland@perry.co.uk> wrote:
>>>>>>>>>>>>> In message <rp3goc$fn7$1@dont-email.me>, at 16:05:30 on Wed, 18 Nov
>>>>>>>>>>>>> 2020, tim... <timsnews99@gmail.com> remarked:
>>>>>>>>>>>>>
>>>>>>>>>>>>>> I remain convinced that "date" format or text, a simple sort cannot
>>>>>>>>>>>>>> give the OP the order that he wants
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> For data stored in ONE field,
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> If it's date format, it will sort on the year as most
>>>>>>>>>>>>>> significant part,
>>>>>>>>>>>>>> if it's text it will get the months in the wrong order
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> please tell us how it is that you are making it work otherwise
>>>>>>>>>>>>>
>>>>>>>>>>>>> I posted a fairly simple scheme to get the data into two fields (aka
>>>>>>>>>>>>> columns), which I think will solve the problem.
>>>>>>>>>>>>
>>>>>>>>>>>> I'm not sure there is a problem to solve. The existing text format would
>>>>>>>>>>>> produce the sort order Hounslow says he wants. So why over-complicate
>>>>>>>>>>>> matters?
>>>>>>>>>>>
>>>>>>>>>>> I took his example six June dates, and added another six in May. Kept it
>>>>>>>>>>> as text (rather than "General" or "Date"), Sorts to:
>>>>>>>>>>>
>>>>>>>>>>> 17.05.2018
>>>>>>>>>>> 17.05.2019
>>>>>>>>>>> 17.06.2018
>>>>>>>>>>> 17.06.2019
>>>>>>>>>>> 18.05.2016
>>>>>>>>>>> 18.06.2016 Which isn't what he wanted[1] because of the months
>>>>>>>>>>> 19.05.2015
>>>>>>>>>>> 19.05.2016
>>>>>>>>>>> 19.06.2015
>>>>>>>>>>> 19.06.2016
>>>>>>>>>>> 20.05.2015
>>>>>>>>>>> 20.06.2015
>>>>>>>>>>>
>>>>>>>>>>> Replace all the dots by slashes, and declare it to be a column of
>>>>>>>>>>> "Dates", sort, and we get:
>>>>>>>>>>>
>>>>>>>>>>> 19/05/2015
>>>>>>>>>>> 20/05/2015
>>>>>>>>>>> 19/06/2015
>>>>>>>>>>> 20/06/2015
>>>>>>>>>>> 18/05/2016
>>>>>>>>>>> 19/05/2016 Which is even less like what he wanted.
>>>>>>>>>>> 18/06/2016
>>>>>>>>>>> 19/06/2016
>>>>>>>>>>> 17/05/2018
>>>>>>>>>>> 17/06/2018
>>>>>>>>>>> 17/05/2019
>>>>>>>>>>> 17/06/2019
>>>>>>>>>>>
>>>>>>>>>>> [1] AFAICT he wants:
>>>>>>>>>>>
>>>>>>>>>>> 17.05.2018
>>>>>>>>>>> 17.05.2019
>>>>>>>>>>> 18.05.2016
>>>>>>>>>>> 19.05.2015
>>>>>>>>>>> 19.05.2016
>>>>>>>>>>> 20.05.2015
>>>>>>>>>>> 17.06.2018
>>>>>>>>>>> 17.06.2019
>>>>>>>>>>> 18.06.2016
>>>>>>>>>>> 19.06.2015
>>>>>>>>>>> 19.06.2016
>>>>>>>>>>> 20.06.2015
>>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> As I understand it, he said he wants exactly your first sort order,
>>>>>>>>>
>>>>>>>>> No, he's specified the third. viz:
>>>>>>>>>
>>>>>>>>>>>> Do you mean you want this sort order?
>>>>>>>>>>>> 17/Jun/2018
>>>>>>>>>>>> 17/Jun/2019
>>>>>>>>>>>> 18/Jun/2016
>>>>>>>>>>>> 19/Jun/2015
>>>>>>>>>>>> 19/Jun/2016
>>>>>>>>>>>> 20/Jun/2015
>>>>>>>>>
>>>>>>>>>>> Exactly
>>>>>>>>>
>>>>>>>>>> though like you, I'm not sure why. It's certainly an unusual way of
>>>>>>>>>> sorting dates, but I suppose I could dream up a logic for it if I had
>>>>>>>>>> to.
>>>>>>>>>
>>>>>>>>> I'm not speculating why, but given the first one of mine is the default
>>>>>>>>> for text fields, why would the OP need to ask for extra help?
>>>>>>>>
>>>>>>>> His problem was that he wanted to sort a block of columns on only one of
>>>>>>>> them, and wanted rows to stay as rows. That's a pretty basic task in Excel.
>>>>>>>
>>>>>>> It's the way their sort works, yes.
>>>>>>>
>>>>>>>> I think all he needed to do to get exactly what he said he wanted was to
>>>>>>>> select the group of columns, before sorting on the text column containing
>>>>>>>> the dates.
>>>>>>>
>>>>>>> But he has a specific (and somewhat unconventional) order he wants the
>>>>>>> sort done in.
>>>>>>>
>>>>>>>> But rather than our endless speculation, we just need him to tell us
>>>>>>>> exactly what he wants, perhaps by choosing one of your three examples. I
>>>>>>>> hope his preferred choice is among them!
>>>>>>>
>>>>>>> What's ambiguous about his comment of "Exactly" under the final scheme
>>>>>>> above?
>>>>>>>
>>>>>>
>>>>>> It contradicts what he said earlier.
>>>>>
>>>>> It's entirely consistent with "I would like to sort this column first by
>>>>> date and month, and then by year".
>>>>>
>>>>>> I just wish he'd provided an example of his own preferred order, or at
>>>>>> least selected one of your three examples.
>>>>>
>>>>> Yes, and I think we are stalemate until he does.
>>>>
>>>> What does this crap have to do with the subject, which is redundancies
>>>> at P&O?
>>>
>>>Look at the date of the message you're replying to!
>>
>>On my newsreader (Agent) every message in the thread is showing as
>>24/03/2022.
>>
>It looks like your indexing might be corrupted.
>("Repair selected folder" on my ancient copy?)

Found it (not where I expected).