Expiration Date

[Snookless]

Hello all,
Please help,
Looking for a formula that will show me all people without an expiration date for a benefit.
Thank you.
Snookless

 

[lyanch]

isnull({table.expirationdate}) might work.. it depends on your schema and other parameters.

Some more info would help.

Lisa

 

[Snookless]

Employees with health benefits, most employees have beginning and end dates, I would like to show only employees without an end date.

 

[synapsevampire]

Using the isnull in the record selection formula (Report->Edit Selection Formula->Record) should work:

not(isnull({yourtable.expirationdate}))

If not, the date probably has another format, so check the values and eliminate them using the same method only with the explicit value for those that are "empty".

-k

 

[Snookless]

Thank you for your help,
I was able to get it to work as follows.
Since Crystal returns a value of 12/30/1899 for a blank date I had to Create a formula field. Name it blank.
IF {EXPDATE} = Date(1899,12,30) then Date(0,0,0) else {EXDATE}.

Then in the select Expert enter, BLANK is equal to 0/0/0
This returned only Employees with a Blank Expiration date for the benefits

 

[synapsevampire]

Crystal doesn't return that value as a default, you probably have the File->Report Options->Convert Null to Default turned on, or your database is defaulting to that value.

-k