How sort by date with incomplete dates (eg year only)?
YYYYMMDD always sorts correctly (unless you have to deal with different
calendars and so on), so is a good working format, but falls down on the
display/readability front. It depnds on which is more important.
Peter Jamieson
"The Horse" wrote in message
...
Word 2007:
I'm constantly creating chronologies where some of the dates are just "May
2003" or even just "2003". When I sort by date, such things are moved to
the
front as if they are not dates at all. Is there some way it can be made
to
work (possibly involving formatting of dates such as "0.0.2003" or
"0.5.2003"
(d/m/y order, UnAmerican I know, but I'm not American).
|