Re: Sort order - Data midified / Created

I hear what you say, and I appreciate your response. But that's not what
should happen. In American English, the date format MM/DD/YYYY is the
standard, and that's how I want the dates displayed, and sorted correctly.
What you suggest is a kludge to get around a Windows flaw. I also use WinXP,
and that seems to work correctly. So the rules were evidently changed between
XP and Vista.

I only hope that in Windows 7, MS gets this fixed. Not that I intend to go
to Windows 7 without being dragged kicking and screaming.

"H Brown" wrote:

Now I understand how you want your Date: values to display.

Try this: open your control panel from the start menu. Now click on "Clock,
Language, and Region", Under "Regional and language Options" find and click
on the sub heading "Change the date, time, or number format" On the Formats
tab click the "Customize this format..." button. Now in this dialog box
that opens, click the "Date" tab. Under "Date formats" there is a drop down
menu that you click called "Short date:" it is here you can choose the
format you would like to have your dates display in. You would choose
yyyy-MM-dd. Now be sure to click the "Apply" button then the "OK" button.

...
H Brown


"VistaXP" <VistaXP@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6E013954-9B71-41C2-8445-B3457BFD772D@xxxxxxxxxxxxxxxx
Thanks for the reply.

I'm on Vista Home Premium.

I view "Details", and the "Date Modified" column is evidently a default,
because I never added it.

All I do is click on the column header and the sort happens, and the
results
are just the way I described them: by MM first, then DD, then YYYY. It
should
be by YYYY first, then by MM, then by DD.

The results I see are along the lines of the example in my original post.

"Field" refers to the area in the record used to control the sort, which
in
this case is a date field. TYPE is the type of field, which is a DATE, not
a
NUMBER or CURRENCY or TEXT or some other TYPE of data.

"H Brown" wrote:

What operating system and edition are you using?

It would also help if you would provide more of a step by step of what
you
do after you open a folder so someone can try and reproduce your
suspected
BUG.

((Example: ( I'm Using Windows (????) (edition) (Sp?). When I open the
Documents folder, set my view to (?). In heading column I add the
headings
Date Created, Date Accessed and Date Modified properties. When trying to
sort files using these Date property columns by clicking in the heading
column for that date property I get the (following results abc...), but
the
results I want and need are (cba...) etc, etc, etc.)

As it concerns Windows Explore, I am unclear what the meaning of your
words
"by fields" and "by TYPE" when you said, as quoted below:

Fields in a sort need to be handled by TYPE. Date fields are NOT the
same
as
numerical fields. When an ascending sort of "1/15/2007, 1/14/2009"
produces
the results of "1/14/2009, 1/15/2007", that is a BUG, and Microsoft
should

In Windows Explorer I'm thinking "Type" is a Property as in *file type*
and
fields are where I input data values to some Property. Did you mean to
say
filters instead of fields?


On my machine in Windows Explorer in the headings column of Date Created,
Date Accessed and Date Modified, I have no problems arranging a sort
just
about any way you, I or someone else would like to see the values of
their
file properties sorted.
Be it ascending or descending sorts, you still scroll down from top to
bottom to view the files in the order you sorted them to.

H Brown

"VistaXP" <VistaXP@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:90FBD24A-18B2-49C7-B591-87C3E7315867@xxxxxxxxxxxxxxxx
This has been asked in many ways in many places, but I've yet to see a
solution to this... when using Windows Explorer to display folder
contents,
and to then sort the files displayed by date (created, accessed, or
modified,
the problem is the same), the files are sorted first by month, then by
day,
then by year. The result is that all "January" date appear first, then
all
days within January, then all years for January dates, and THEN all
February
dates, etc. This is not how a sort by date is done.

Any first year programming student knows that when sorting by date, the
result HAS to be chronological. Why doesn't Microsoft know this?

Fields in a sort need to be handled by TYPE. Date fields are NOT the
same
as
numerical fields. When an ascending sort of "1/15/2007, 1/14/2009"
produces
the results of "1/14/2009, 1/15/2007", that is a BUG, and Microsoft
should
fix it.

Is there, or is there not, a workaround for this?

Thanks.




.

Loading