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
Solved

Word  2010 Table Sorting

Posted on 2013-10-25
6
655 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
Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

 
LVL 32

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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Shortcuts in Word Just the other day I had a training for Microsoft and they wanted me to show how well the new Windows and Office behaved on a touch device, which by the way is great, but it was only then that I realized that using keyboard shortc…
This is written from a 'VBA for MS Word' perspective, but I am sure it applies to most other MS Office components where VBA is used.  One thing that really bugs me is slow code, ESPECIALLY when it's mine!  In programming there are so many ways to…
In this video, we show how to convert an image-only PDF file into a PDF Searchable Image file, that is, a file with both the image (typically from scanning) and text, which is created in an automated fashion with Optical Character Recognition (OCR) …
Office 365 is currently available in five editions. Three of them are for business use: Office 365 Business Essentials, Office 365 Business, and Office 365 Business Premium. Two of them are for home/personal use: Office 365 Home and Office 365 Perso…

856 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