Skip to Content
0
Former Member
Oct 20, 2008 at 10:05 PM

include those records that have Null End Dates

19 Views

I have to pull a report that show those who are currently working so we are assuming those with no End Dates are still working. When I put '0' or '0/0/00' for the End Date I get an error stating I need to put in a date.

How do I only include those records that have Null End Dates? Ultimately I need a count of those currently employed. So I'm assuming once my report only shows those records I can add a running total field.

I have Crystal XI.

Thanks