Hi,

I have Crystal Reports 12.7.1.2131 on Windows 7.

I have the following formula as a field on my report:
-----------------------------------------------------------
if ({Command.due_dte} < currentdate) AND (isnull({Command.rcp_num})) then
    "OVERDUE " & truncate(currentdate - {Command.due_dte}) & " day(s)"
else if ({Command.due_dte} = currentdate) AND (isnull({Command.rcp_num})) then
    "DUE TODAY"
-----------------------------------------------------------

The issue I have is with this function:
truncate(currentdate - {Command.due_dte})

Say the answer is 12, it will return 12.00.  I initially tried the round function before the truncate function but they all return a value with 2 decimal places.

Does someone know why this may be the case?

thanks

jc