Awesome everyone thank you.  This fixed the problem I was having.  I sorted dates in access tables and cleaned up junk dates...conversion worked for all tables!