Actually, I figured it out that is not my problem. The problem is in SQL this gets me the correct results.
'2015-05-05' BETWEEN vs.start_date AND COALESCE(v.discharge_date,CURRENT_TIMESTAMP) SQL I get
21 records. IN Crystal I get 51.
In cyrstal this appears to now work right.
{?Date} IN {ABSTJ.start_date} TO (if isnull({ABSTJ.discharge_date}) THEN CurrentDateTime)
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum