Hi All,

Does anyone know a way to check for null dates so that I can write a suppress condition for a date field if they are null.

I am using RDS to run my report and sometimes I have to pass a null date, I pass 0 to the RDS date field. The report displays it as '30/12/1899', I would like to write a condition to suppress a date object if its null, something similar to:

Code:
return {OrderHea.Order_Date}=0

I've tried hard coding the date '30/12/1899' (ie. return {OrderHea.Order_Date}=0) as my null date checker and it works fine but I have a feeling that this will not always be the case and will come back to bite me in the future!

So bottom line, if there isnt a way.. Would it be possible to have a function or an option for date fields to say "Suppress if null date" similar to "Suppress if Zero" for Integer fields (See Image Below).


Click image for larger version. 

Name:	Capture.PNG 
Views:	110 
Size:	15.2 KB 
ID:	10962


Regards,

Rol