Date with condtional formatting 1

[techkenny1]

Hi,
I am using this code on a continous form to show specific data when a certain date criteria is reached.

Expression is

DateDiff("d",[DateRaised],Date())>30

This will hightlight all dates that are over 30 days.
What I need to do is to be able to show 30 days, 60 days in different colours.
How do I change the above code to reflect this.

Many thanks

kp

 

[dhookom]

You can create up to 3 conditional format expressions. Your first condition might be:
[DateRaised] Between Date()-30 and Date()-60
Play with it until it's correct.

Duane
Hook'D on Access
MS Access MVP