Word 2010 Table Sorting

Table has a "Date" column and we are sorting by that date. The dates don't seem to be sorting exactly by date.

What are the rules for sorting by date? Do the dates have to be in a very specific format? Do they, for instance have to be xx/xx/xxx?

If there is 1/5/2013 does it need to be 01/05/2013 in order to sort?
LVL 1
mrmythAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Eric FletcherConnect With a Mentor Commented:
Word's sort is pretty good at interpreting mixed Date format types, but some formats are guaranteed to be misinterpreted. Consider the example below:Table of dates sorted by Date and by Text types The "YYYY-MM-DD" format is the least ambiguous, and will sort correctly with "Type:" set to either Text or Date. Dropping the zero padding (as YYYY-M-D and variants) is less useful because October will sort before May in a Text sort -- but note that a Date sort still works fine. Similarly, other formats won't sort properly with Type=Text, but Word manages to cope with the mix of numbers and text strings pretty well.

Dates entered with ambiguous formats like M/D/YY or D/M/YY are next to impossible to sort reliably. Is "5/4/13" May 4 or April 5? (The most extreme situation is a M/D/Y format: should "2/3/4" represent Feb 3 2004 or Mar 2 2004 or March 4 2002?) If you use any of these date formats, you'll have to be rigorous in using them consistently to have any hope of sorting them properly. (And good luck to anyone who needs to interpret them in the future!)

The most reliable way to ensure proper sorting is to stick to the number format used in your operating system preferences. (In Windows 7, use Control Panel > Clock, Language, and Region > Region and Language > Change the date, time, or number format.) However, although my Win7 preferences are set to "yyyy-MM-dd", Word was able to interpret the dates as shown in the screen shot above.
0
 
Steven HarrisConnect With a Mentor PresidentCommented:
Mine seem to work fine, even with mixed formats.

Word Table Sort
With that said, you should try to keep a very consistent format.  Since you are having issues, I would suggest  xx/xx/xxxx.

Also, what sort option are you using?  This is what I tested with:

Word Sort Option
0
 
mrmythAuthor Commented:
I am using the setting you have pictured above but with a header row, the date column just says DATE as a header.
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
Steven HarrisPresidentCommented:
So you notate it has a header row with the radio buttons, right?

Still not working properly?
0
 
Paul SauvéRetiredCommented:
Is the date dd/mm/yyyy or mm/dd/yyyy (as posted above by ThinkSpaceSolutions)?OoopsDoesn't seem to work!
0
 
mrmythAuthor Commented:
thank you!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.