How to write multiple conditions

[abc567]

Hi,

I am required to write a condition like,

NumberVar df= Datediff('d',Field1, Field2);

if
(
0 < df <=50
)

then
1
else
0


But i am unable to write it in formula..

 

[Madawc]

Try a formula field with

Datediff('d',Field1, Field2)

Then another with

If @Diff <=50
then 1
else 0

For most purposes, formula fields are easier than variables.


Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP

 

[lbass]

I would change that last formula to:

If {@Diff} >= 0 and
{@Diff} <= 50 then
1 else 0

Make sure you have syntax set to Crystal syntax (above the formula area).

-LB