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?)