Following code works if rs("Acct_D") = Any Valid Date from DB2 in
YYYY-MM-DD format......but does not work if the date in DB2 table is "0001-01-01" ......while running it gives "Type Mismatch" error.....

Dim EXCPDATE as String
EXCPDATE = Format(rs("Acct_D"), "MM/DD/YYYY")

If the date (from db2 table) is "0001-01-01" then I have pass spaces..........

Any Suggestions - Thoughts - ideas..........would be appreciated !!!

Thanx !!!