SQL how do i select using the current month 1

[Leej2000]

I am using SQL to Query a database to select fields for the current month but i am unable to do so so far i have used the following

Select *
From stockTrans
Where stocktrans.date = #**/(now)/**#

How ever this isnt working. All it needs to do is to select the current month items and disregard everything else is this possible and how do you do it?

 

[TimKThailand]

Do you have only records in this year? Just in case you need to select records in current month and year, then try this out.

Select *
From stockTrans
Where DatePart("mm",stocktrans.date) = DatePart("mm",getdate())
and DatePart("yy",stocktrans.date) = DatePart("yy",getdate())

 

[Leej2000]

cheers Tim will try that out. i believe that they could be more records for over the years. thankyou for your help
Lee