Re: Can't sort by date

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


"Gary Brown" <GaryBrown@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9C3C1F97-1CC3-43A8-94EB-D74ED9C7787B@xxxxxxxxxxxxxxxx

Aha!!! I got it. I changed the format to double check that the "20" that
isn't displayed in the year was actually "20", and low and behold, for the
first two dates in the ascending sequence, it was 19. So 1931 and 1933 were
sorting on top.

Thanks all for looking over my shoulder!


> 1) give us an example
Ascending:

7/16/31
9/30/33
1/17/06
5/15/06
5/26/06
8/15/06
12/29/06
3/22/07
3/15/09
10/1/09
12/15/10
3/15/13
1/15/18
10/1/19


Descending
10/1/19
1/15/18
3/15/13
12/15/10
10/1/09
3/15/09
3/22/07
12/29/06
8/15/06
5/26/06
5/15/06
1/17/06
9/30/33
7/16/31


> 2) could time be causing the 'randomness'?
> HTH,
> Gary Brown
>
>
> "Laurel" wrote:
>
>> How can I sort a spreadsheet by a column full of dates? Even though type
>> is
>> "date" when I sort by that column, the result seems to be random. I
>> can't
>> make sense of the order even assuming it is sorting like text. The sort
>> does happen, because it changes when I switch between ascending and
>> descending.
>>
>>
>>


.

Relevant Pages

  • Re: Module Cruelly Kissed to Death by -O2
    ... It makes a huge difference in a merge sort and brings g95's ... descending 0. ... ascending 0. ...
    (comp.lang.fortran)
  • Re: Can this be done?
    ... I ALWAYS sort by name ascending and date descending - its a golden rule ... > In this code page paste in the following sub: ...
    (microsoft.public.excel.misc)
  • Re: Sort Formula
    ... This sorts in ascending order, ... To sort in descending order, text before numbers, replace the SMALL ... No intermediate ancillary calculations in other cells needed. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: sorting question
    ... report's Sorting and Grouping to sort the report's records. ... primary key and therefore automatically sorts ascending. ... by all other ID's in ascending order which is not exactly what I'd ... The sorting issue still needs to be addressed. ...
    (microsoft.public.access.reports)
  • Re: Applying Reports Sort Order via code
    ... Ascending is False, Descending is True according to the help file. ... Now the users want to be able to sort the ...
    (microsoft.public.access.reports)