Crystal Reports Time Difference

Message

   Hi All!

I need to find the difference between the airtime of current record and next record.
When I try to run the report, I get Bad Time format String error.
I use the following formula:-
--------------------------------------------------------------------------------------
LOCAL DATETIMEVAR D1;
LOCAL DATETIMEVAR D2;
D1:=DATETIMEVALUE(CDATE({Command.AIR_DATE}),CTIME(currentfieldvalue));

IF NEXT({Command.AIR_TIME}) <> "" THEN
  D2:=DATETIMEVALUE(CDATE(NEXT({Command.AIR_DATE})),CTIME(NEXT({Command.AIR_TIME})))

if not onlastrecord and next({Command.AIR_TIME}) <> "" then
cstr(datediff("n",D1,D2))
ELSE
CSTR({Command.EVENT_DURATION});
----------------------------------------------------------------------------

Thanks
dhakshu

Edited by dhakshu - 11 Jun 2007 at 1:22am