Help Formatting Parameter Date Range in a Concatenated Formula

[omcompany]

I am trying to bring in the date range parameters for a report. I believe I could simply use text boxes and the {?BeginDate} and {?EndDate} fields to accomplish this but I was wanting to concatenate the two fields as such, {?BeginDate}& " to " &{?EndDate}.

My issue is the date format is set so that the range shows as, 11/1/2011 12:00:00AM to 11/15/2011 12:00:00AM. I am however not able to format the formula. Is there something I can do to the concatenation formula to format the dates?

I changed the format for the parameters to 11/1/2011 but that did not change the @DateRange formula results.

I also tried this formula, (ToText({?BeginDate},'MM/DD/YYYY')& " to " &ToText({?EndDate},'MM/DD/YYYY')) and the @DateRange results show as “11/DD/YYYY to 11/DD/YYYY”. (Any light on why this formula gave these results would be welcomed.)

My desired result would be “11/1/2011 to 11/15/2011”.

Thanks in advance for any assistance. The help is appreciated.

 

[lbass]

ToText({?BeginDate},'MM/dd/yyyy')& " to " &ToText({?EndDate},'MM/dd/yyyy')

The case matters.

-LB

 

[omcompany]

LB

Thank you very much.