I have this conditional formating calc.

(ProcessTracking::P10ReviseDate >= ProcessTracking::P10PlanDate &#8211; 7) and  (ProcessTracking::P10ReviseDate < ProcessTracking::P10PlanDate)

The complaint is with the "P10PlanDate - 7", how do I subtract days from a field.

In a previous iteration which was doing the wrong thing but worked was......

(ProcessTracking::P10ReviseDate  > Get ( CurrentDate ))  and  (ProcessTracking::P10ReviseDate  ≤ Get ( CurrentDate ) + 7)

Thanks

Michael

Please explain, in plain human language, what is the condition you want to apply,

Comment,

What I am trying to achieve is that if the ReviseDate set is within 7 days prior to reaching PlanDate and less than PlanDate the field goes yellow, alerting the user.

I have another conditional formatting calc that turns the field red when plan date is reached and/or passed.

All fields are defined as date.

ReviseDate set is within 7 days prior to reaching PlanDate and less than PlanDate

That would be =

PlanDate - 7 < ReviseDate and ReviseDate < PlanDate

 

However, if you have another condition for ReviseDate ≥ PlanDate, then =

 

PlanDate - 7 < ReviseDate

should be quite sufficient - provided the other condition is subsequent to this one.

Comment,

Works, thank you.