>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
Jon Rosenbaum
Devcon Drummer