Solved

Word  2010 Table Sorting

Posted on 2013-10-25
6
642 Views
Last Modified: 2013-11-07
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?
0
Comment
Question by:mrmyth
6 Comments
 
LVL 18

Assisted Solution

by:Steven Harris
Steven Harris earned 100 total points
ID: 39601913
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
 
LVL 1

Author Comment

by:mrmyth
ID: 39601976
I am using the setting you have pictured above but with a header row, the date column just says DATE as a header.
0
 
LVL 18

Expert Comment

by:Steven Harris
ID: 39601980
So you notate it has a header row with the radio buttons, right?

Still not working properly?
0
Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

 
LVL 31

Expert Comment

by:Paul Sauvé
ID: 39602014
Is the date dd/mm/yyyy or mm/dd/yyyy (as posted above by ThinkSpaceSolutions)?OoopsDoesn't seem to work!
0
 
LVL 21

Accepted Solution

by:
EricFletcher earned 400 total points
ID: 39602801
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
 
LVL 1

Author Closing Comment

by:mrmyth
ID: 39632621
thank you!
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It is often necessary in this forum and others to illustrate Word fields as text with the field delimiters replaced with the curly brackets that the delimiters resemble when field codes are being displayed on the document. This means that the text c…
I'm writing to share my clumsy experience in using this elegant tool so you can avoid every stupid mistake I made. (I leave it to the authorities to decide if this deserves a place in the Knowledge archives.)  Now that I am on the other side of my l…
This video teaches the viewer how to align pictures around text while keeping the text properly aligned in the document.
In a previous video Micro Tutorial here at Experts Exchange (http://www.experts-exchange.com/videos/1358/How-to-get-a-free-trial-of-Office-365-with-the-Office-2016-desktop-applications.html), I explained how to get a free, one-month trial of Office …

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question