>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