I want to create a report that shows all tickets older than 30 days. I assumed that I would subtract the date the ticket was logged from the current date, but have had no luck. This is the formula that i have tried.
Whileprintingrecords;
Datevar Open:=Date({CallLog.RecvdDate});
Datevar Current:=Date(CurrentDate);
NumberVar Days:=(Current-Open);
If(Days)>= 30 Then 1 else 0
This is reporting from the HEAT 5.01 Problem Management Database.
Thanks,
Jeff
Whileprintingrecords;
Datevar Open:=Date({CallLog.RecvdDate});
Datevar Current:=Date(CurrentDate);
NumberVar Days:=(Current-Open);
If(Days)>= 30 Then 1 else 0
This is reporting from the HEAT 5.01 Problem Management Database.
Thanks,
Jeff