Hi,
I have a list of equipment, the equipment interval repair (equip.cal_interval) is 12 month or 24month, but if the interval is either early or later that the interval it suppose to, it will show the status, whether it 'change' or 'same'
the interval is count by equip.cal_date - equip.due_date
My field are:
equip.cal_date
equip.cal_due_date
equip.cal_interval
equip.status
What is the 'not' syntax in crystal report?
I understand it should be but I am not sure whether my query is correct
if {equip.cal_date} - {equip.cal_due_date} != {equip.cal_interval}
then {equip.status} = 'change'
else
{equip.status}= 'same'