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

--
anandmr6
-----------------------------------------------------------------------
anandmr65's Profile: http://www.excelforum.com/member.php...fo&userid=3072
View this thread: http://www.excelforum.com/showthread.php?threadid=53915

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