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

  • Thread starter Thread starter DEVOURU
  • Start date Start date
D

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
 
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"
 
Back
Top