are there date varables to use with 'automatic formating'

[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.

 

[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.

 

[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.

You need to create a formula using the DateDiff() function. Look up
the Help on that function on how to use it.

 

[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.

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.