Date comparison in VBA (MS Acess)

[anandmr65]

Hi,

I am trying to retreive some records after a certain date in exce
using VBA. The database is MS access. I am using the following query
it gives an error.
Select * from Datatable
where ModDate > format('01/21/2006', '\#mm/dd/yyyy\#').

Could somebody enlighten me how to use the date field in wher clause.

Thanks in advance for your help.

regards
Anan

 

[arthurjr07]

Try this,
Select * from Datatable
where ModDate > #01/21/2006#