Sort Dates in a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to sort a table based on a column of dates. The problem is, some
of the dates are in MM/DD/YY format, and others are in MM/YY format and some
are even undated. Is there a way to do this?
 
I have a few questions.

Have yor tried the menu commands "Table" and "Sort?"

How do you propose sorting something by date if if isn't dated? Is it
something that occurred but you don't know when or something that will
occur and you don't know when? Your answer will have significant
bearing on how your final list will look.

Good luck.
 
On the undated entries, they are events that occurred but I don't know when,
and can all be placed at the top of the table. My main concern is where
events happened in a month but I don't know a date, and they are listed as
MM/YY as opposed to DD/MM/YY; I want events that happened on October 2006 to
be sorted after events of 09/30/06 and before 10/01/06. Thanks.
 
Back
Top