Cannot get MonthToDate formula to work

[elsenorjose]

Hi all,

This isn't working the way I thought it would. I get an error saying 'A number range is required here' and 'MonthToDate' is highlighted. My formula thus far is:

(If month({v_TurnaroundMetricsReportForAPI.MSN_Approval_Date}) in MonthToDate
And month({v_TurnaroundMetricsReportForAPI.LN_Approval_Date}) in MonthToDate
Then 1 Else 0)

I want to use the results of the formula to do a summary on records that have both dates in MonthToDate. I am also getting a similar error when using YearToDate in the formula.

Can someone help me correct this?

I'm using CR XI on SQL Server 2005.

Thank you.

 

[lbass]

If {v_TurnaroundMetricsReportForAPI.MSN_Approval_Date} in MonthToDate And
{v_TurnaroundMetricsReportForAPI.LN_Approval_Date} in MonthToDate Then
1 Else 0

You should be testing whether the dates are in monthtodate, NOT whether the months are.

-LB

 

[elsenorjose]

Thanks LB. I should have known that.