Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

include those records that have Null End Dates

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

replied

Try entering some default value for null like enter a default date "1/1/1900" which means that the end date is null.

Now in the record selection write the condition like this

if {?EndDateParameter}=date(1900,1,1) then
(isnull(datefield)=true or totext(datefield)="")
else
datefield={?EndDateParameter}

Regards,

Raghavendra

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question