for current month and year (Resolved)

I'm using crystal reports 10. I need to select only records for the current month and current year. I've tried to figure it out in the select expert, but it is beyond me. Can anyone help?

in the select expert choose forumla from the dropdown box
and add the following:

Code:

---

Month ({Report.YOUR_DATE}) = Month (CurrentDate) AND
Year ({Report.YOUR__DATE}) = Year (CurrentDate)

---

where Report is the name of your table and YOUR_Date is the name of the field.
you can use the Show Formula and Forumla Editor to help you.

Thanks, It works great!