Skip to Content
0
Former Member
Jul 17, 2008 at 08:33 AM

Date comparison

26 Views

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'