I am new to Crystal Rpts...I am trying to write a selection criteria formula. Here is what I am trying to say..

if the temp.date is empty (null) but the perm.date had a date (not null)

then pull all records where that perm.date is < the projected.date and a perm.date is in a date range for the projected.date (projected.date{?start date} to projected.date {?end date})

also pull

all records with a projected.date that is between the projected.date {?start date} and projected.date {?end date}

here is what I wrote:
(isnull({temp.date}) and not isnull({perm.date}) and
{perm.date} < {projected.date} and
{projected.date} in {?sdate} to {?edate}

this is only returning records with perm.dates

any suggestions?

Thank you for your reply.

There are two tables both have been pulled into crystal. the perm.date and the temp.date are from one table and the projected.date is from another table. so it really should have read...status.perm_date and status.temp_date then projectedstatus.projected_date.