Hi,

I am new to Crystal and have gotten myself in over my head.

I am trying to calculate a field based on three fields, and thought I could use some IF-THEN logic but am not figuring it out.  Specifically, I want to calculate a total number of days based on three different date fields.  I was hoping to use a formula field and have it:


If {DATE2} <= {DATE3} then {TOTAL_DAYS} = {DATE3}-{DATE1} + 1

else {TOTAL_DAYS} = {DATE3}-{DATE1} - 1

When I try to save the formula field, Crystal does not like my IF-THEN...

Can I use this logic in a formula field or is this not possible?

I would appreciate any thoughts...

Thanks

Thanks very much..