Fields:
Dispatch Date: Misc Date 9
Dispatch Time: SA215
Officer Arrival Date:  Misc Date 10
Officer Arrival Time:  SA216
Officer Completion Date:  Misc Date 11
Officer Completion Time:  SA217

What I want to do is combine the appropriate date and time together, and get the difference, and then get the average.  What I am ultimately trying to do is get the average response time.

 

Here is my formula so far:

stringvar dx := {IRSCLAIMSA1.SA215};
timevar dy := time(val(left(dx,2)),val(right(dx,2)),0);
datetime dz := datetime({IRSCLAIM.MISC9_DT},dy);

stringvar ax := {IRSCLAIMSA1.SA216};
timevar ay := time(val(left(ax,2)),val(right(ax,2)),0);
datetime az := datetime({IRSCLAIM.MISC10_DT},ay);

datediff("n",dz,az);

 

I get to the third line and at datetime it highlights the rest of the formula and says"the remaining text does not seem to be part of the formula.  Can someone help me? Thanks in advance!