SQL query on VB date

[sankur]

hi all!
i wanted to create an SQL query that gets the invoices for a specific month i.e. Invoices dated in one month say, November.

I'm using the data control for my connection to the database. Can anyone give me the code for such a kind of SQL query.

 

[CmPaiva]

Try

SELECT * FROM <yourtable> WHERE Month(<yourdatefield>)=11

This is 11 for November

I Hope this helps,
Carlos Paiva