Date problem

[APH]

Hi I really have a block where Date is concerned.

Can some kind person show me the syntax if I was to query all records from a
table where the month is equal to current month?

Thanks

Alex

 

[Brian Camire]

If you only want records from the current month *in the current year*, you
might use a WHERE clause that looks something like this:

WHERE
[Your Table].[Your Date Field] >= DateSerial(Year(Date()),Month(Date()),1)
AND
[Your Table].[Your Date Field] < DateSerial(Year(Date()),Month(Date())+1,1)