Pls help with expression in conditional formatting

[Guest]

I tried the following expression on my form and the expression below does not
work. What am I doing wrong?


I need help on setting a conditional formatting to a control in a form. I
want this date field_2 to look another date field_1. If date field 1 is
greater by 7 days than date field 2 than "BOLD" and "red". Can this be done?
I tried setting this but it will not do anything. I hope you can help me
with this. thank you in advance for any help you can provide.

Set teh condition1 to
Expression Is
Set the expression to:
[Date1]-[Date2]>=7

Set your font color and bold as wanted.

 

[Steve Schapel]

TotallyConfused

You have done this correctly, so I can't see why it doesn't work for
you. Date1 and Date2 are both Date/Time data type fields, right? And
Date1 really is 7 or more days after Date2, right? Check that there is
not a Time component to the data, that may be making you think it is 7
days after, but actually less than 7 days because of the time.