Boolean Type Result for a DateTime Formula

[Former Member]

While attempting to check the following formula:

DateDiff ("d", {CallSheets.tClosedDate},{CallSheets.tOpenDate},1);

A Boolean result is expected when the check is performed.

What is wrong?

[abhilash_kumar]

Hi Serafino,

This formula returns the difference between two dates in days.

Where are you using this code?

-Abhilash

[Former Member]

This is being used in crystal reports.  I  thought the interval type may conflict with the field type.

Then i simply declared the datetimeVar as a variable, with the argument is a datetime field as well.

datetimeVar d1 := {CallSheets.tMaintDate};

When I checked the formula I received the following message.

“The result selection of the formula must be a Boolean”

[abhilash_kumar]

I mean to ask where in the report are you using this formula?

Record Selection? Formatting formula? Group selection?

And, what are you you trying to achieve?

-Abhilash

[Former Member]

I was attempting to calculate the number days using a formula in the Record Sselection as I want to remove weekends.  Regardless, I have to enter the Var formulas separately, and filter out the weekends separately.  It cannot be run together in the Record Selection.