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

[DEVOURU]

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!

-JS

 

[Steve Schapel]

JS,

Try it like this, in the Control Source of an unbound textbox on the
report...
=IIf([adate]>0,Format([adate],"mm/dd/yyyy","Text")

Alternatively, you could set the Format property of the [adate] control
on the report to...
mm/dd/yyyy;;"Text"