Steve,
Did you just use those functions in an expression for the report field? They should work quite nicely there.
>In my report I print an Average at the Group Footer level. The average is appearing as 27.666666. My report content is built by a SELECT command with a cursor named RPT as the output of the SELECT statement.
>
>I would like it to read 27 without the decimals.
>
>My Group Footer Report Expression Window shows expression -
>INT(CTOD(rpt.EndDate) - CTOD(rpt.StartDate))
>
>I have tried FLOOR(), CEILING(), INT(), etc., but no help.
>
>My Calculate Field Window shows -
>Reset: rpt.status
>In other words, I calculate the average number of days elapsed whenever the status code changes.
>Calculate - Average radio button is clicked on.
>
>I want to report the Average Number of Days Elapsed.
>
>My Detail Report Expression Window shows expression -
>CTOD(rpt.EndDate) - CTOD(rpt.StartDate)
>The number of days elpased for a certain status code record.
>
>Any idea what's wrong?