I was given the following formula in my question regarding
summarizing a date/time field. However I get an error message from CR when i check it.
The error message is inserted at the point I get it:
WhilePrintingRecords;
numberVar dur;
numberVar hrs;
numberVar sec;
stringVar hhmmss;
dur = sum(dtstoseconds(totext({incidentsm1.handle.time})))
THE REMAINING TEXT IS NOT PART OF THE FORMULA
hrs :=Truncate(Truncate(dur/60/60);
min :=Remainder(Truncate(dur/60),60);
sec :=Remainder(dur,60);
hhmmss:=totext(hrs,"0"+":"+totext(min,"00" + ":" + totext
(sec,"00"
hhmmss
Can anyone tell me what is wrong ?
Regards,
TomH
Norway
summarizing a date/time field. However I get an error message from CR when i check it.
The error message is inserted at the point I get it:
WhilePrintingRecords;
numberVar dur;
numberVar hrs;
numberVar sec;
stringVar hhmmss;
dur = sum(dtstoseconds(totext({incidentsm1.handle.time})))
THE REMAINING TEXT IS NOT PART OF THE FORMULA
hrs :=Truncate(Truncate(dur/60/60);
min :=Remainder(Truncate(dur/60),60);
sec :=Remainder(dur,60);
hhmmss:=totext(hrs,"0"+":"+totext(min,"00" + ":" + totext
(sec,"00"
hhmmss
Can anyone tell me what is wrong ?
Regards,
TomH
Norway