Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    Phoenix, Arizona, USA
    Posts
    31
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Fuzzy date (Word 2003)

    Is there some way to use a fuzzy date in a Word table. In indexing historic documents, not all of them have full date. Sometimes I have only a year, or a month and a year. I want to be able to sort by date. I can get the sort to work if I use 1 but not 0, for instance we have only the year 2002. I tried 0/0/2002, 2002, the able will not sort. But if I use 1/1/2002 I can sort by date. Another entry is 8/2001. I have found that I have to use 8/1/2001 for the date sort to work. This is ok, but can prove confusing down the road. When someone believes 8/1/2001 is the actual date of the document or event. The 0 would be a better solution, no one would likely mistake that for a real date. I have tried searching help for a fuzzy date, the Word forum, Microsoft's product solutions center, but I don't come up with any discussions. Thanks.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Fuzzy date (Word 2003)

    You could use three separate columns: Year, Month, Day. If the day and/or month is missing, leave the corresponding cell blank. Word allows you to sort a table on up to three columns.

  3. #3
    Lounger
    Join Date
    Jan 2001
    Location
    Phoenix, Arizona, USA
    Posts
    31
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Fuzzy date (Word 2003)

    Thanks. That works. It seems like a lot of extra trouble, but it works and that's what counts. Thanks so much.

  4. #4
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Zoetermeer, Zuid-Holland, Netherlands
    Posts
    559
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Fuzzy date (Word 2003)

    I had the same problem a few years ago and solved it in a different way. Put an extra column in the table. Have a macro check the date, convert it to text in the yyyymmdd format. If there's only a year, add 4 trailing zero's and if it's a year and a month, add 2 trailing zero's. Place the converted date in the extra column and you can use that to perform the sort.

    Later I tried to find the macro, but it was for a on-off project and I'm afraid it's lost. <img src=/S/sad.gif border=0 alt=sad width=15 height=15>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •