If the date is more than 6 weeks ago....

[Kirstie Adam]

Can someone please tell me the expression for the following?

I have 2 date fields [Date Issued] and [Response Received]

Using conditional formatting in a report, i want [RESPONSE RECEIVED] to turn
yellow if it's null and [Date Issued] was more than 6 weeks ago.

All help much appreciated, as always!

Kirstie

 

[Steve]

[RESPONSE RECEIVED] Is Null And [Date Issued] < DateAdd("w",-6,Date())

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[Marshall Barton]

Can someone please tell me the expression for the following?

I have 2 date fields [Date Issued] and [Response Received]

Using conditional formatting in a report, i want [RESPONSE RECEIVED] to turn
yellow if it's null and [Date Issued] was more than 6 weeks ago.

Set the CF expression to

[Response Received] Is Null And DateDiff("d", [Date Issued],
Date()) > 42