cannot format 12/30/1899 or 12:00:00 AM



Day 2, and I am looking for a tip or two. I have a ODBC link with a VFP
table. There is a Date/Time field that will show either 12/30/1899 as a
date, or 12:00:00 AM if not a date. I tried conditional formatting, Also
IIF([adate]=#12/30/1899#, "TEXT",[adate]) i get #ERROR. I would like to
place text when this value is present. TIA!


Steve Schapel


Try it like this, in the Control Source of an unbound textbox on the

Alternatively, you could set the Format property of the [adate] control
on the report to...

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question