CR 9 - formula for selecting null date

[CalgaryCR9]

I'm using Crystal Version 9, Oracle, Sql.

My oracle table "System_Item" has a field call "END_DT". Apparently this can be a null value according to my DBA.

How do I write a record selection formula to select those records with a null END_DT?

 

[CalgaryCR9]

Solved on own:

created formula @end_dt that read:

if isnull({SYSTEM_ITEM.END_DT})
then date(3000,01,01)

then put in details, suppressed, and entered record selection of selecting end_dt of 3000-01-01

 

[Turkbear]

Hi,
Or, use

IsNull({SYSTEM_ITEM.END_DT})

as your record selection formula - no need for the If..Then..






To Paraphrase:"The Help you get is proportional to the Help you give.."