If ( Contract_Expiry < Get ( CurrentDate ) ) ; 1 ; 0 )
"want the contract_status field to have a value of 1 if the contract expiry_date is before today
I want the contract_status field to have a valkue of 0 if the contract_expiry date is after today"
... and what if contract_expiry IS today? You haven't allowed for it in the above. :^)
Anyway, you can use simple Boolean calculation (be sure to set the Storage Options to do not store) and the result of the calculatoin should be number. By using Boolean, it simplifies the evaluation and automatically produces 1 or 0 so it can be:
Contract_Expiry < Get ( CurrentDate )
Thank you both,