Date ranges for Subreports CR v 9.0.

[cfriedberg2]

I am creating a report that displays data for a certain period of time. In order to get the YTD values, I want to summarize in one line the YTD data as a subreport. In order to link the reports I want to take the data from January 1 of the year in question to the last date in the primary report.

I created the Select Records formula as follows:
{Command.date} >= DateValue("01/01/" & ToText(Year({?Pm-@MaxDate}))) and {Command.date}<= {?Pm-@MaxDate
But when I display the report, I get "bad format string" as an error message. I would like a simple method of displaying the YTD data.

 

[synapsevampire]

For the error use:

{Command.date} >= DateValue("01/01/" & ToText(Year({?Pm-@MaxDate})),0,"") and {Command.date}<= {?Pm-@MaxDate

-k