J
James
how can i change the color of tasks that were created more than 1 month ago.
i tried using =date() - 30 but that doesn't work.
i tried using =date() - 30 but that doesn't work.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
Ken Slovak - [MVP - Outlook]
You need to create a formula using the DateDiff() function. Look up
the Help on that function on how to use it.
the Help on that function on how to use it.
J
James
are you talking about using VBA? because i want to do this right from the
filter form in outlook's automatic formating section for defineing views.
filter form in outlook's automatic formating section for defineing views.
Ken Slovak - said:You need to create a formula using the DateDiff() function. Look up
the Help on that function on how to use it.
K
Ken Slovak - [MVP - Outlook]
No, in an Outlook form. Open the Properties window for the control
where you want to display your calculated result and go to the Values
tab. There is a button there to open a formula builder and you can
select various functions there. You can select DateDiff there and use
that in your formula.
You won't be able to do what you want without designing a custom form
and adding a control to it to display your results. The control would
have to be bound to an Outlook UserProperty that is added to the
folder as well as the item. At that point you can use the Field
Chooser to add that calculated field to your folder view.
Other than that what you want can't be done.
where you want to display your calculated result and go to the Values
tab. There is a button there to open a formula builder and you can
select various functions there. You can select DateDiff there and use
that in your formula.
You won't be able to do what you want without designing a custom form
and adding a control to it to display your results. The control would
have to be bound to an Outlook UserProperty that is added to the
folder as well as the item. At that point you can use the Field
Chooser to add that calculated field to your folder view.
Other than that what you want can't be done.
views.James said:are you talking about using VBA? because i want to do this right from the
filter form in outlook's automatic formating section for defineing