IsNull 2

[needmoremoney]

Hello,

I'm try to set a Select Expert formula.

I want to set it to pull data if the field EInfo.termDate is null or greater then 12/31/2004. I don't know how to write the formula.

Any help please let me know.




I'm using crystal 8.5.

 

[BobSuruncle]

Rather that using the "Select Expert", write the selection formula by hand.
Go to the Report Menu -> Edit Selection Formula -> Record

Try this :
IsNull({EInfo.termDate}) OR {EInfo.termDate} > Date(2004,12,31)

Bob Suruncle

 

[needmoremoney]

Thanks, I just got it too. I added the >= to the date. Thanks much Bob...

 

[Turkbear]

Hi,
If {EInfo.termDate} is actually a Date ( or DateTime) field, then IsNull will not work, you will need to use

( {EInfo.termDate}= Date(0,0,0) Or {EInfo.termDate} >= Date(2004,12,31) )





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

 

[needmoremoney]

Turkbear,

Thanks sooo much. You are absolutely right. This IsNull function does not work. I tried yours and it worked perfectly. Thanks so much..