ASPNetGuy:That still didn't work. I don't really understand what is happening here but...If I Open Excel and use the SQL Editor I can use this StatementSELECT * FROM BLPSO WHERE BLPSO.SORTDT = '01/01/0001'if I use the wizard then it returns stuff that has a date 01/01/2001If I use DAO in VB6 it also returns stuff that has a date 01/01/2001JustSomeGuy:I couldn't find what I was looking for in that search or any other searchthat I did. I even tried using stuff like "date returned as 01/01/2001 instead of 01/01/0001"Not sure if I'm just missing what I need to see or what.Still don't have it worki