Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error message

Status
Not open for further replies.

THI

Technical User
Feb 12, 2002
7
NO
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
 
You've missed a semi-colon at the end of the line dur = sum(dtstoseconds(totext({incidentsm1.handle.time})))

If you get this error message, 99% of the time you're missing a semi-colon Andrew Baines
Chase International
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top