Sort by Null Date 1

[adminbydefault]

Using Crystal 8.5.
I am a complete newbie to Crystal and I need some assistance with a filter. I need to create a report that only list active employee's. I am using EmployeeTerminationDate to accomplish this. My problem is I need to display all employee with a termination date that isnull. In other words if there is no date in this field display the information.

The date in the data file is stored as 00000000 if no date assigned, otherwise yyyy/mm/dd.

I tried filtering using the standard options available with no luck, so it looks like I will need a formula to accomplish this.

Any help or suggestions on how I can achieve my desired results would be greately appreciated.

Thanks in advance.

Adminbydefault.

 

[synapsevampire]

Go to the Report->Edit Selection Formulas->Record and place:

(
not(isnull({table.date})
and
{table.date} <> "00000000"
)

-k

 

[lbass]

I think you want a record selection formula of:

isnull({table.date}) or
{table.date} = "00000000"

-LB

 

[adminbydefault]

Thanks synapsevampire and lbass for the suggestions. I will give them a shot and post the results.

Adminbydefault

 

[adminbydefault]

Thanks again synapsevampire and lbass for the suggestions.

lbass your suggestion did the trick. I ended up using

isnull({table.data})

Worked Great!

Thanks

Adminbydefault