Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Oct 2004
    Posts
    63
    Thanks
    0
    Thanked 0 Times in 0 Posts

    sort by dates with inconsistant format (Outlook 2000)

    I need to make an document listing items by date and I need to be able to sort by date. The problem I am running into is the dates of the items are inconsistent. One item may have a date such as 11/20/2004, the next only the year. Is there a way to enter items that don't have the dd/mm/yy or dd/mm/yyyy format and have them all sort? Thanks

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

    Re: sort by dates with inconsistant format (Outlook 2000)

    You can add a calculated column that contains real dates, and sort on that. For example, assuming all dates are in 1930 or later, enter this formula in C2:

    =IF(A2>DATE(1930,1,1),A2,DATE(A2,1,1))

    and fill down as far as necessary. Sort on column C. See attached version.

  3. #3
    Star Lounger
    Join Date
    Oct 2004
    Posts
    63
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: sort by dates with inconsistant format (Outlook 2000)

    I see what you mean but that assigns a month and date and we can't have that. These are publication dates. One might be an article published on a certain date, another could be an annual report that's only date is the year and we need to show it that way. I tried replacing the 1s in the formulas with 0 but it didn't work. Any other suggestions? Thanks

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

    Re: sort by dates with inconsistant format (Outlook 2000)

    You could keep the original column for display purposes and use the calculated column only for sorting.

    If that is not what you want, you will have to explain what you do want.

  5. #5
    Star Lounger
    Join Date
    Oct 2004
    Posts
    63
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: sort by dates with inconsistant format (Outlook 2000)

    That could do the trick. Thank you your prompt responses. I appreciate all the help on get from folks here in the Lounge!

Posting Permissions

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