... at which point (doing it for every DATE field encountered in *any* data format) the message truly does become redumdant.

It's what fills the field that matters, not the (correctly formatted) field itself. The message only raises anxieties for no good reason - possibly even letting some to use it as "proof" of sense to discontinue FP/VFP.


Cheers,

Jim N

>>>That's fine, if it does this to *all* DB products -- but if it singles out x-base, as Ivan thinks, then that's exhibiting some "bias" isn't it?
>>
>>Hopefully it raises this error for Access et al. Ivan could you test this on an Access database?
>
>Exactly, and how about SQL Server, too?