"Cannot Sort By this Field" - Outlook 2010 - Custom Field

Posted on 2011-10-17
Last Modified: 2012-05-12
HI, I have made a custom field in Outlook in my tasks using a formula. The formula is using a iif to pick dates or text. So the field has dates or the word "None". I would like it converted to a datefield and then sort by it.
I have tried Datevalue(....) and it seems to work. But when I try to sort it Outlook says "Cannot Sort By This Field."
I really want to use this field to choose which Task to do next.
Question by:CitySunrise
    LVL 5

    Expert Comment

    Please check this solution :

    Hope it will work for you.


    Author Comment


    I can view the website but I don't see a solution.
    Sorry but Thanks.
    LVL 53

    Expert Comment

    I've requested that this question be deleted for the following reason:

    This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

    Author Comment

    I would like to leave this open a while longer. Seriously if I had wanted it closed I would have closed it.
    Maybe someone will see it. It is a question that relates to common topics. Outlook, and Programming should have many people viewing it. And it is one that would be VERY benificial to me now and years from now. So a couple of months is nothing.
    LVL 47

    Assisted Solution

    by:Dale Fye (Access MVP)
    You cannot change the datatype to date as long as you have values of  "None" in your computed field.  

    You can have Date values and NULL values, but no text values.
    LVL 21

    Accepted Solution

    You could either use a "bad" date (I.E. 1/1/1800) or null if you want to stick with dates.

    f you convert the dates to strings then you COULD use "NONE".  The only way dates are sortable as string is if you change the format to YYYY/MM/DD (4 digit year followed by 2 digit month followed bu 2 digit day).

    There are workable solutions, it is up to you if they fit your needs.

    Author Comment

    No time right now.

    Author Comment

    I would love to know a way if you can explain. I don't care so much about the word "none"  as much as I want to sort by a custom date field and to have some without real dates.
    I want a custom field because I am trying to use iif to choose the latest of two other custom fields.

    Task           Answer                Custom 1         Custom 2
    Task 11                                   None                None
    Task 3                                     None                None
    Task 2       01/12/2012            None                 01/12/2012
    Task 12     01/13/2012            01/13/2012       01/14/2012
    Task 1       01/20/2012            01/20/2012       01/20/2012

    Thanks so much for you help.

    LVL 11

    Expert Comment

    This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    Outlook setting 3 32
    Re-indent word doc 5 28
    python sqlite question 11 24
    Search Outlook Items 13 26
    The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
    An overview on how to enroll an hourly employee into the employee database and how to give them access into the clock in terminal.

    733 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now