help with Crystal Report SQL command

I created a report using Crystal report 9. One of the table is a SQL command, this table has a column name 'Month' which is int(2). This report will be schedule to run monthly, and I need the sql script that will return only the rows that have the same month as the current month.
currently, I have to manually change the sql statement to select from the current month.

thanks for the help.

i figured it out. here is the command.
datepart(month,convert(char(8),getdate(),10)))
this command will return a month integer.