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

  • Thread starter Thread starter Kirstie Adam
  • Start date Start date
K

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
 
[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)
 
Kirstie Adam said:
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.
Click to expand...


Set the CF expression to

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