Using field information to display result 1

[ccanalia]

I am working on a report where there are two dates listed, an enroll date and an exit date. I am trying to write a formula that will show the enrollment status based on the dates that are listed. If there is an end date the enrollment status would be "Closed" if there is not an end date then their enrollment status would be "Enrolled." I am new to using Crystal Reports and this goes way over my head. Please help.

 

[synapsevampire]

To save everyone time, post the following here, and with any post at least include your software version:

Crystal version
Database/connectivity used
Example data
Expected output

The formula should work with something like the following:

If isnull({table.enddate}) then
"Enrolled"
else
"Closed"

This assumes that the default of the enddate field is a null. If not, code accordingly.

Hope this resolves, and have a good weekend.

-k