Formula generates two values on date field

[griffter]

Hi all

I am trying to return an actual visit date that a patient visit took place.

I have used the formula:-
If {tbl.thisismyvisitid} then
{tbl.thisismyactualdate}

However I appear to generate one date time value and one date value, crystal is then seeing these as two rows of detail, additionally I am creating a summary on this formula and it is counting one type of visit where none have taken place (I presume this is the 'rouge' value it is picking up)

Does anyone have any idea why I am returning two values from this formula???

Thanks, in anticipation

 

[dgillz]

Your formula makes no sense. Is {tbl.thisismyvisitid} a boolean (true/false) field?

What if you simple place {tbl.thisismyactualdate} on the report canvas, do you still see 2 values?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz