Hi, I'm pretty useless with Crystal Reports and there is no one in my office who has a clue...

I am trying to count the number of days between when projects start and end.  The problem is when there is no end date (the project isn't finished).  How do I write a formula that will count the days when there is an end date and substitute todays date when there is no value in the end date column?

I have tried this:

if (end_date)-(start_date)>0
then (end_date)-(start_date)
else (current_date)-(start date)

but it doesn't work.  How can I tell Crystal to recognize the null values in the end date column and insert todays date?

Thanks for your help!