#1   Report Post  
peturpin
 
Posts: n/a
Default Sorting dates

How do I troubleshoot sorting dates in Word? I've already checked to make
sure I have forward slashes, but that didn't help.
  #2   Report Post  
Cindy M -WordMVP-
 
Posts: n/a
Default

Hi ?B?cGV0dXJwaW4=?=,

How do I troubleshoot sorting dates in Word? I've already checked to make
sure I have forward slashes, but that didn't help.

Version of Word?

Which country (USA, England, other) date format would you use?

Which country date format is set up in the Windows Control Panel?

Are you trying to sort dates in text, in a table, something else?

Finally, could you give us a few examples of the dates you're trying to sort,
for testing purposes?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)

  #3   Report Post  
Peturpin
 
Posts: n/a
Default

I believe that this is Microsoft Word from the Office 2003 Software Pack.

I tried using two different date formats that I've seen the the USA:
MM/DD/YY and MM-DD-YY.

The date format set up under Regional and Language Options in the Control
Panel is M/D/YYYY.

I am trying to sort dates in a table.

Examples of dates I'm trying to sort: 05/13/05, 06/07/05, etc.

If the date format is set up in the Control Panel as shown above, does that
mean that dates need to be listed in the same manner in Word in order to be
sorted correctly in tables?

Thank you for your time, I appreciate it.

Peturpin
--
Peter Turpin
Cultural Liaison
West Central Integration Collaborative
611 5 St SW
Rm 354
Willmar, MN 56201-3218
USA
(320) 231-8573
FAX: 1 (320) 231-8559


"Cindy M -WordMVP-" wrote:

Hi ?B?cGV0dXJwaW4=?=,

How do I troubleshoot sorting dates in Word? I've already checked to make
sure I have forward slashes, but that didn't help.

Version of Word?

Which country (USA, England, other) date format would you use?

Which country date format is set up in the Windows Control Panel?

Are you trying to sort dates in text, in a table, something else?

Finally, could you give us a few examples of the dates you're trying to sort,
for testing purposes?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)


  #4   Report Post  
Suzanne S. Barnhill
 
Posts: n/a
Default

I don't think so. If you set the sort type as Date (and often Word will
figure this out on your own), it should sort dates intelligently. Have you
tried it?

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Peturpin" wrote in message
...
I believe that this is Microsoft Word from the Office 2003 Software Pack.

I tried using two different date formats that I've seen the the USA:
MM/DD/YY and MM-DD-YY.

The date format set up under Regional and Language Options in the Control
Panel is M/D/YYYY.

I am trying to sort dates in a table.

Examples of dates I'm trying to sort: 05/13/05, 06/07/05, etc.

If the date format is set up in the Control Panel as shown above, does

that
mean that dates need to be listed in the same manner in Word in order to

be
sorted correctly in tables?

Thank you for your time, I appreciate it.

Peturpin
--
Peter Turpin
Cultural Liaison
West Central Integration Collaborative
611 5 St SW
Rm 354
Willmar, MN 56201-3218
USA
(320) 231-8573
FAX: 1 (320) 231-8559


"Cindy M -WordMVP-" wrote:

Hi ?B?cGV0dXJwaW4=?=,

How do I troubleshoot sorting dates in Word? I've already checked to

make
sure I have forward slashes, but that didn't help.

Version of Word?

Which country (USA, England, other) date format would you use?

Which country date format is set up in the Windows Control Panel?

Are you trying to sort dates in text, in a table, something else?

Finally, could you give us a few examples of the dates you're trying to

sort,
for testing purposes?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question

or
reply in the newsgroup and not by e-mail :-)



  #5   Report Post  
Peturpin
 
Posts: n/a
Default

Yes, I have tried sorting according to date, but it sorts the entries
according to no identifiable order, or it doesn't sort them at all.

Thanks for your thoughts, I welcome any other questions or suggestions about
this.

Peturpin
--
Peter Turpin
Cultural Liaison
West Central Integration Collaborative
611 5 St SW
Rm 354
Willmar, MN 56201-3218
(320) 231-8573
FAX: 1 (320) 231-8559


"Suzanne S. Barnhill" wrote:

I don't think so. If you set the sort type as Date (and often Word will
figure this out on your own), it should sort dates intelligently. Have you
tried it?

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Peturpin" wrote in message
...
I believe that this is Microsoft Word from the Office 2003 Software Pack.

I tried using two different date formats that I've seen the the USA:
MM/DD/YY and MM-DD-YY.

The date format set up under Regional and Language Options in the Control
Panel is M/D/YYYY.

I am trying to sort dates in a table.

Examples of dates I'm trying to sort: 05/13/05, 06/07/05, etc.

If the date format is set up in the Control Panel as shown above, does

that
mean that dates need to be listed in the same manner in Word in order to

be
sorted correctly in tables?

Thank you for your time, I appreciate it.

Peturpin
--
Peter Turpin
Cultural Liaison
West Central Integration Collaborative
611 5 St SW
Rm 354
Willmar, MN 56201-3218
USA
(320) 231-8573
FAX: 1 (320) 231-8559


"Cindy M -WordMVP-" wrote:

Hi ?B?cGV0dXJwaW4=?=,

How do I troubleshoot sorting dates in Word? I've already checked to

make
sure I have forward slashes, but that didn't help.

Version of Word?

Which country (USA, England, other) date format would you use?

Which country date format is set up in the Windows Control Panel?

Are you trying to sort dates in text, in a table, something else?

Finally, could you give us a few examples of the dates you're trying to

sort,
for testing purposes?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question

or
reply in the newsgroup and not by e-mail :-)






  #6   Report Post  
Doug Robbins
 
Posts: n/a
Default

On my machine (Word 2003 on Windows XP) with the Control Panel short date
format set to M/d/yyyy, the following dates

05/13/2005
04/15/2005
07/02/2005
04/12/2005

get sorted correctly to

04/12/2005
04/15/2005
05/13/2005
07/02/2005

and spaces before or after a date do not prevent the sort from being
performed.
--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
"Peturpin" wrote in message
...
Yes, I have tried sorting according to date, but it sorts the entries
according to no identifiable order, or it doesn't sort them at all.

Thanks for your thoughts, I welcome any other questions or suggestions
about
this.

Peturpin
--
Peter Turpin
Cultural Liaison
West Central Integration Collaborative
611 5 St SW
Rm 354
Willmar, MN 56201-3218
(320) 231-8573
FAX: 1 (320) 231-8559


"Suzanne S. Barnhill" wrote:

I don't think so. If you set the sort type as Date (and often Word will
figure this out on your own), it should sort dates intelligently. Have
you
tried it?

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup
so
all may benefit.

"Peturpin" wrote in message
...
I believe that this is Microsoft Word from the Office 2003 Software
Pack.

I tried using two different date formats that I've seen the the USA:
MM/DD/YY and MM-DD-YY.

The date format set up under Regional and Language Options in the
Control
Panel is M/D/YYYY.

I am trying to sort dates in a table.

Examples of dates I'm trying to sort: 05/13/05, 06/07/05, etc.

If the date format is set up in the Control Panel as shown above, does

that
mean that dates need to be listed in the same manner in Word in order
to

be
sorted correctly in tables?

Thank you for your time, I appreciate it.

Peturpin
--
Peter Turpin
Cultural Liaison
West Central Integration Collaborative
611 5 St SW
Rm 354
Willmar, MN 56201-3218
USA
(320) 231-8573
FAX: 1 (320) 231-8559


"Cindy M -WordMVP-" wrote:

Hi ?B?cGV0dXJwaW4=?=,

How do I troubleshoot sorting dates in Word? I've already checked
to

make
sure I have forward slashes, but that didn't help.

Version of Word?

Which country (USA, England, other) date format would you use?

Which country date format is set up in the Windows Control Panel?

Are you trying to sort dates in text, in a table, something else?

Finally, could you give us a few examples of the dates you're trying
to

sort,
for testing purposes?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow
question

or
reply in the newsgroup and not by e-mail :-)






Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Dates formatting in Word Paul - NottsUK Mailmerge 1 May 22nd 05 08:02 AM
Sorting by Dates Chris Wagner Microsoft Word Help 1 May 13th 05 01:00 AM
Tracking Changes - Entering dates of changes Lisa Glase Microsoft Word Help 1 March 3rd 05 10:14 AM
Can I link 2 dates in a document so changing 1 changes the other? alux999 Microsoft Word Help 1 February 4th 05 05:24 PM
How do I compare dates in a Word IF field? Marion G Microsoft Word Help 0 December 10th 04 01:47 AM


All times are GMT +1. The time now is 08:11 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"