Suppress converted date

[mmwdmr]

Crystal 10 on Oracle

The date field I am trying to work with is represented as a number in the database. I am using this formula to convert the number to a date:

(DateSerial ((int({F0006.MCD4J}/1000)+1900),1,{F0006.MCD4J} mod 1000))

If the field in the database is 0.00 then the formula converts it to 12/31/1899 (which I have displayed on the report). What I need to do is suppress the field if it is equal to 12/31/1899. I am not sure of the syntax I would use in the Suppress option of the Format Formula Editor.

I know it's not coming to me because it's an easy solution!

Thanks

 

[Turkbear]

Hi,
If I understand what yo want, dothios:
Right-click on the formula field in the Report( where it is displayed) and, right-click to open the format..suppress..x*2 section and enter
{F0006.MCD4J} = 0.00





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

 

[synapsevampire]

If you just want to eliminate them from the report entirely, use Report->Selection formulas->Record:

{F0006.MCD4J} <> 0

As Turk points out using = would also work for suppression if you prefer to suppress (eliminating is better if you don't need those rows).

-k