#Error Help Needed

[mattc66 via AccessMonster.com]

Need help. The End_Date field is bland and if so formating it returned a
#ERROR in the field when I run a query. I thought I could do an IIF(IsError(..
.. to remove it, but I am having trouble with the syntax. Below is what I
thought would work, but it's not working.

Can anyone see the errors in my ways?

E_DATE: IIf(IsError([END_DATE]),"",Format(DateSerial(Left([END_DATE],2),Mid(
[END_DATE],3,2),Right([END_DATE],2)),"mm/dd/yyyy"))

 

[John Spencer]

You might try the following

IIF([End_Date is Null, End_Date, Format(CDate(Format(End_Date,"@@/@@/@@"))))

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Duane Hookom]

You might be able to use IsNull([your field or expression here]) rather than
IsError().