for current month and year (Resolved)

[purdybirds]

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?

[DeadEyes]

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

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.

[purdybirds]

Thanks, It works great!