Let function calc problem

[IEW]

The follwing script works for d > 14 and turns days_return red. However, I cant get it to work for d < 14 and leave days_return black. Any ideas? TIA

Ivan

If (Return_Date > 1 ;

Let (d = Return_Date-InvoiceDate;

If ( d > 14; TextColor ( Days_Return ; RGB ( 255 ;0 ; 0)))))

[comment]

Try:

Case (

Return_Date - InvoiceDate > 14 ; TextColor ( Days_Return ; RGB ( 255 ; 0 ; 0 ) ) ;

Days_Return

)

I didn't catch the significance of Return_Date > 1.