Automatic setting for rules in MS OUTLOOK

[lywong111]

Is there anyway to set the rules for the view such that the view will display field1(type is date) row in RED when field1 is 10 days later from TODAY??
In my automatic setting rules condition, I put:
'Field1' 'Between' 'Today and 10 days later'
This condition ONLY works for if today is 04/27/04 (date of entering the rules).

I wanted to display all item that are btw 'Today and 10 days later' in RED. those not within this range will remain in black color. Once my system date changes say to tomorrow(04/28/04), it shld oso change from 04/27/04 - 05/07/04, To: 04/28/04 - 05/08/04.

Instead, it still display only till 05/07/04.

How do I set it such that it's able to reflect the correct date once my system date changes??

Pls advice. Thanks

 

[Lightning]

Try something like:

'Field1' 'Between' 'Date() and (Date + 10)'

I haven't tried this myself, so you may need to play around with the syntax to get it right.

HTH
Lightning

 

[lywong111]

Hi Lightning,

It dun work.
Whenever you haf a numeric value there, it will take that value as the date.
EG if put:
Field1 Between Today and (Date()-30)

The outcome will be:
Field1 Between Today and 05/30/04

If put -5, date will become 05/05/04

Which is obviously wrong.

I'vr already tried many combination but it just dun work.
Pls advice again. Thanks!

 

[Lightning]

Sorry, I've hit the end of my knowledge of Outlook. It's something I try to avoid as much as possible.

Hopefully some guru from this forum will step in and give you the answer.

Good Luck