hhmmss conversion problem

[mgallot]

I am trying to convert to hhmmss from a duration field that contains seconds. I'm using CR 9.0 and SQL Server. I keep getting a message that the 'remaining text does not appear part of the formula'. What am I missing?

whileprintingrecords;
numberVar dur := {GCDR.Duration}
numberVar hrs;
numberVar min;
numberVar sec;
stringVar hhmmss;

hrs := Truncate(Truncate(dur/60)/60);
min := Remainder(Truncate(dur/60),60);
sec := Remainder(dur,60);

hhmmss := totext(hrs,"00") + ":" + totext(min,"00") + ":" + totext(sec,"00");

hhmmss

 

[synapsevampire]

Forgot the semicolon after the {GCDR.Duration}:

whileprintingrecords;
numberVar dur := {GCDR.Duration};
numberVar hrs;
numberVar min;
numberVar sec;
stringVar hhmmss;
hrs := Truncate(Truncate(dur/60)/60);
min := Remainder(Truncate(dur/60),60);
sec := Remainder(dur,60);
hhmmss := totext(hrs,"00") + ":" + totext(min,"00") + ":" + totext(sec,"00");
hhmmss

 

[mgallot]

Perfect! Thanks.