The accounting department needs to redo the budget. I was tasked with creating this years income based on February's dates first.

I am creating a cross-tab report (assumed this would be easiest).

I am able to get every day that income was received but I want only the month of 2011 to display with the sum of these items.

This is what I created for my formula.

if {ACCOUNTING_AUDIT_TRAIL.TRAN_DATE}=MonthName(February) and
{ACCOUNTING_AUDIT_TRAIL.TRAN_DATE}=Year(2011)
then
{ACCOUNTING_AUDIT_TRAIL.TRAN_DATE}

When I check this i get the following error:

the ) is missing

Is there an easier or better way that I am not thinking of?

Its telling me on my first field that a number is required here. This field displays date and time. It is a string field. Does that matter in this case?