captgriggs1
asked on
Response time <= 5.00 then 1 else 0
Hello,
I'm trying to get the number of days that a call was open, I keep getting 1 instead of the total which should be about "X" for the dates that I'm using. The ClosedIn5 is what I'm working on. I have included the fields that it uses. Thanks!
Formula Fields
ClosedIn5
if {CallLog.CallStatus}='Clos ed' and {@Closed Date} in {?Begin Date} to {?End Date} and
{@ResponseTime} <= 5.00 then 1 else 0
ResponseTime
if {@Closed Date} in {?Begin Date} to {?End Date} then HFWDurNumDateHelpdesk ({CallLog.RecvdDate},{Call Log.Closed Date})
ClosedDate
Hfwdatetodate({CallLog.Clo sedDate})
BeginDate
cdate ({?Begin Date})
EndDate
cdate ({?End Date})
I'm trying to get the number of days that a call was open, I keep getting 1 instead of the total which should be about "X" for the dates that I'm using. The ClosedIn5 is what I'm working on. I have included the fields that it uses. Thanks!
Formula Fields
ClosedIn5
if {CallLog.CallStatus}='Clos
{@ResponseTime} <= 5.00 then 1 else 0
ResponseTime
if {@Closed Date} in {?Begin Date} to {?End Date} then HFWDurNumDateHelpdesk ({CallLog.RecvdDate},{Call
ClosedDate
Hfwdatetodate({CallLog.Clo
BeginDate
cdate ({?Begin Date})
EndDate
cdate ({?End Date})
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.