Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Word  2010 Table Sorting

Posted on 2013-10-25
6
Medium Priority
?
736 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 18

Assisted Solution

by:Steven Harris
Steven Harris earned 400 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
On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

 
LVL 33

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:
Eric Fletcher earned 1600 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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Nice table. Huge mess. Maybe this was something you created way back before you figured out tabs or a document you received from someone else. Either way, using the spacebar to separate the columns resulted in a mess. Trying to convert text to t…
Introduction This tutorial provides instructions on how to properly format your Word document using the inbuilt tools provided. The benefits of using these tools means your documents are more accessible and easily portable to other applications an…
This video walks the viewer through the process of creating a watermark for their document, customizing it, and saving it for viewing/printing needs.
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 …

719 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