>Hi Jon,
>
>I created a new formula field called "mdatecert" and in the formula editor I put in "date(1899,12,30)".
>
>From there I went to the select expert and added the following:
>
>{MC.DATE_CERT} = {@mcertdate}
>

Jim,

For starters, your formula references "mcertdate" and you say you created a new field called "mdatecert" - hopefully that was just a typo? :)

I tried a test in my own report using a formula and just using the Date() function and I got it to work without a hitch. In the record selection formula, why not just get rid of the "middle man" and just say:

{mc.date_cert} = Date(1899,12,30)

Do you have any other selection criteria set up or did you add something in the where clause of the SQL query?

Laterness,
Jon