Null Value Filter!!!!!!! 1

[anandwaits]

hi guys,

I have a scenario where i have to handle the null values in the filter (say, in the WHERE condition i need (START_DATE is NULL) or (START_DATE >= ?Startdate))
How can i get this expression.

I have to create this in formula editor or SQL Expression editor.

Can anybody help in this issue.

Anand

 

[Turkbear]

Hi,
Have you tried

START_DATE = Date(0,0,0)

If START_DATE is actually a Date or DateTime field this should eliminate NULLS ( I'm not sure Crystal's
IsNull(START_DATE) works on Date fields)
- If it is a text field used as a date then test for
Trim(START_DATE) = ""





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

 

[dgillz]

This should do the trick if they are truly null:

Isnull({StartDate}) or {StartDate}>={?StartDate}



Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz