Hi All,
I have a contract start date and contract end date field. It's possible to create if statement for status field like this below
If date is more than 30 days before contract end date, contract status field is active
if date is 30 days before contract end date, contract status field is will expired
if date is equal contract end date, contract status field is expired?
How can I achieve this?, Can you please give me step by step direction for this?
Many thanks
------------------------------
Syaeful Bahri
------------------------------