To get Date in Ms-Access using SQL Query Wizard

select * from table1 where doj> datevalue( "11/11/2009" )