comparing just the month in a date field

[biosol]

Hi,
i'm trying to run a cfquery where the (Access) Date/Time field is compared to a month (as a number). My dates are stored in this format 12/12/02. I've tried this code in the WHERE statement without success:

DatePart(m, MI.meeting_date) = #session.current_month#

however, there are a couple problems i don't know how to fix. i have a table with numbers and month names that i need to query to get the number of the month to compare it to the stored value.

date field is in MI.meeting_date, # and names of months are in table Months

suggestions? TIA

 

[object]

where month(MI.meeting_date) = #session.current_month#

 

[biosol]

that was it. thanks!!