Hi

I am hoping someone can help me to do the below.

I have two fields 1 "Letter Sent" field(date) and 2 "Letter Received" field (date). I would like the "Letter Received" field to go red if no dated entered 7 days after the date entered in "Letter Sent" field.

I hope that makes sense.

Try:

YourTable::Sent and not ( Self ) and Get ( CurrentDate ) > YourTable::Sent + 7

 

Edited September 28, 20169 yr by comment

Thanks for this  the field "Letter Received" field is red to begin with is there a way to have this not be red to start with?

2 hours ago, KassK said:

"Letter Received" field is red to begin with

You mean when the Sent field is empty? Try the edited version above.

your awesome, thank you so very much