Conditional formatting using dates and text

[rplohocky]

Hello,
I am trying to conditionally format a field on my form. This what I wrote so far.
<code>
(([OXI Install Date]-Now()) And [Integration Status]="Oracle Order Sent") Between 22 And 13<code/>

I am trying to make the "OXI Install Date" field change to red when the current date reaches 21 days before the date entered in the "OXI Install Date" field and when the field "Integration Status" field says "Oracle Order Sent".

Basically when the date entered reaches 21 days away from the OXI date and the Integration field reads "Oracle Order Sent"the OXI field turns red.

Can anyone help?

 

[pbaldy]

Your logic is off for starters. Try

([OXI Install Date]-Now() Between 22 And 13) And [Integration Status]="Oracle Order Sent"

I'm not sure Between works in CF, so you may need to test for <= and >=.