Do not print out NULL date

[sane79]

How do I prevent the printing of the Date field in CR8.5 if the value in the database is null?

Currently what I get for a null field is 30/12/1988....

I do not what that field to appear at all...

 

[synapsevampire]

Try:

if {table.date} <> CDate(1988,12,30) then
totext({table.date})
else
&quot;&quot;

-k

 

[synapsevampire]

LBass offered an option in another post too:

if {table.date} <> CDate(1988,12,30) then
{table.date}
else
cdate(0,0,0)

-k

 

[sane79]

Hi all.. thanks.. Do i put this code under the Select expert in CR or..?

 

[synapsevampire]

That depends on what it is you want to do.

If the intent is to elimate all of the rows where there is an empty date (not what you originally asked for), then you might use the following in the record selection formula:

{table.date} <> CDate(1988,12,30)

If you want to show thee data for those rows, but don't want the oddball dates that are being returned by the database, create a formula to use as the date in lieu of the date field containing one of the above formulas.

-k

 

[sane79]

Hi K.

I tried putting ur code into the record selection of the date field in my report..
BUt I get an error: &quot;This field name is not known&quot; with the cursor at &quot;&quot;.
Can u pls pt to me where i went wrong?
Sorry for asking some stupid questions.. cuz I'm actually quite new to CR.. thanks.