>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,

Darn typo's.

I took your advice and and tried the record selection formula "mc.date_cert = date(1899,12,30) but still no luck.

To make sure I checked my table out again and out of a totla of 1,030 records there are 477 with no date in the date_cert field, so I know the table is okay.

I tried this "mc.date_cert = date(1999,9,15)" and three records appeared in the report which is acurate.

The "mc.date_cert = date(1899,12,30)" still shows no records :(

There are no other selection criteria.

This is a free table in the old fox2x type structure.

I hope I'm not doing something stupid but I didn't think it should be this difficult.

Thanks,

Jim