Can't query date from feature class table join.

Discussion created by ruffino75 on Apr 27, 2010
Latest reply on Apr 29, 2010 by lshipman-esristaff
I am trying to figure out why I am unable to query out dates from a table ( join between a feature class and a table). I can verify the sql statement and it is okay but once I "ok" it , no records are returned and I get an error message ( see attachment). I'm sure I'm overlooking something obvious , so any help that could point me in the right direction would be greatly appreciated.