Selecting a NULL value in a formula

[creekmetal]

I have records from a payroll database that have both a begin date and an end date if the employee is terminated.If the employee is still employed the "End Date" value is blank (does not say NULL). How do I create a formula to select only the records that have a begin date and an open or "null" end date?

 

[kskid]

not(isnull({table.begindate})) and
isnull({table.enddate})

 

[CR85user]

Just to qualify that - if the value is NOT null for end date but IS blank then check for that also. If it is date type then default date may apply - if it is string type then it could be blank.


not(isnull({table.begindate})) and
(isnull({table.enddate}) or {table.enddate} like '')

'J

CR8.5 / CRXI - Discovering the impossible