Custom View for Tasks in Outlook 2010 - I want to combine Start Date and Due Date in one column or have a custom filter
Hi, I want to use Outlook as a work flow system. Meaning I want to creat a task or to-do and have the following basic columns "Task Name", "Status Column", "Start Date" and "Due Date".
When I sort I want to see everything due first. Which means if the "Status" column is Not Started then the "Start Date" is the Column to sort by. But if the "Status" column says In Progress then the "Due Date" is the column to go by.
So the only 2 ways I can think to do this are to either have a custom column that has the Start date if the "Status" column is Not Started and the Due Date if the "Status" column is Not in Progress.
The second way would b to have a custom filter in the Manage Views.
I don't care how it is done I just want to see what I need to do next. And the date is deceptive because the task may have already been started.
I would also love to hear of any ideals you may have to be better organized in Outlook.
Thanks.
When I sort I want to see everything due first. Which means if the "Status" column is Not Started then the "Start Date" is the Column to sort by. But if the "Status" column says In Progress then the "Due Date" is the column to go by.
So the only 2 ways I can think to do this are to either have a custom column that has the Start date if the "Status" column is Not Started and the Due Date if the "Status" column is Not in Progress.
The second way would b to have a custom filter in the Manage Views.
I don't care how it is done I just want to see what I need to do next. And the date is deceptive because the task may have already been started.
I would also love to hear of any ideals you may have to be better organized in Outlook.
Thanks.
johanntagle
I don't understand how this is related to MySQL database. Can you clarify?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
johanntagle
I choose topics to get help to answer the questions. Since I may need a custom column I need someone who can write the statement. The statements are very similar to Transact SQL. It isn't the database I care about it is someone who works with it and has the skills to write the column. Someone who has ever written a stored procedure and had to convert dates could probably write what I needed. Why?
DavidT543
Thanks.
I don't need anyone else to have this just me.
A custom view would be fine to use but I think it still means a custom column unless I am missing something.
I did want to try to use a custom field to sort by, but when I have tried to build one I can't sort by it. And since they are dates and I would need to use a formula I don't know the syntax to exclude the time.
Thanks.
I choose topics to get help to answer the questions. Since I may need a custom column I need someone who can write the statement. The statements are very similar to Transact SQL. It isn't the database I care about it is someone who works with it and has the skills to write the column. Someone who has ever written a stored procedure and had to convert dates could probably write what I needed. Why?
DavidT543
Thanks.
I don't need anyone else to have this just me.
A custom view would be fine to use but I think it still means a custom column unless I am missing something.
I did want to try to use a custom field to sort by, but when I have tried to build one I can't sort by it. And since they are dates and I would need to use a formula I don't know the syntax to exclude the time.
Thanks.
ASKER
I just reread my answer. I hope it didn't come across as rude.
ASKER
I believe what I really need can't be done in Outlook currently. But thanks for your reply.