I have a date field that is formatted with a formula. It is RED if the date is 30 days old from the current date AND the next date is equal to 1/1/1753 (which, in the data table means null).
if {OPPOR.ENDDAT_1} <= currentdate -30 and
{OPPOR.ENDDAT_2} = date(1753,1,1) then
crRed else crBlack
What I would like to do, is add another condition that makes the font GREEN if the date is within a week of currentdate ( >= currentdate -7.
When I try to add this other condition, I keep getting a boolean error. How do I add this 2nd condition so the date font is either RED, GREEN, or Black (when there is an actual activity date in the next date field).
IP Logged
