Help with relative date

[Shoe Fairy]

Hi, I'm using the issues database template with a bit of modification and I'm
tracking customer complaints.
On the issues form I have the date issue is raised and the date it is due to
be closed (i.e. within 30 days).
I want to generate a 'flag' in which some text will highlight depending on
todays date.
For example if todays date is before the due date, the status is OK and
green; if it is within 5 days before the due date I want the status to be
orange and due now; and if past the due date, then red and overdue.
Can someone help me with the expressions I need?
Thank you
Sherri

 

[Michel Walsh]

From within a form, have you tried the conditional formatting? In design
mode, select the control, then, from the menu, Format | Conditional
Formatting...


Vanderghast, Access MVP.

 

[Shoe Fairy]

That is what I want to do but I can't get my code to work. Any help?

 

[Michel Walsh]

Have you tried:

Field Value Is, between, Date() -30 , Date() -1



and choose the formatting you want to see if the field value is a date
between 30 before today and yesterday.




Hoping it may help,
Vanderghast, Access MVP