boolean is required

[Monkey820]

What am I doing wrong?

if {@Balance} < 0 then red else black or
if {V_ORD_DTL_AVALIABILITY.PROMISE_DATE} < CurrentDate then red else black or
if {V_ORD_DTL_AVALIABILITY.PROMISE_DATE} <= CurrentDate + 7 then Blue else black

I am getting an error that a boolean is required before the 2nd "black"
tia
Gertie

 

[synapsevampire]

Try:

if {@Balance} < 0
or
if {V_ORD_DTL_AVALIABILITY.PROMISE_DATE} < CurrentDate then red
else
if {V_ORD_DTL_AVALIABILITY.PROMISE_DATE} <= CurrentDate + 7 then
Blue
else
black

-k

 

[Monkey820]

sorry, did not work,
error is
"the keyword 'then' is missing"

at the end of the formula

 

[synapsevampire]

Sorry, try:

if {QUARTWAGE.COMPANY} < 0
or
currentdate < CurrentDate then
red
else
if currentdate <= CurrentDate + 7 then
Blue
else
black

-k

 

[Monkey820]

THAT WORKED!
THANKS!!!