Concatenate 2 date fields to show longdate format

How can I concatenate 2 date fields so that they show the date in long format i.e 18 March 2006 to 21 March 2006. I can get the expression to concatenate but I want to format the dates as above.

Thanks

I believe you can use this...

=CDate(Fields!date1.Value).ToString("dd MMMM yyyy")&" to "&CDate(Fields!date2.Value).ToString("dd MMMM yyyy")

where you can replace the fields where appropriate.

Craig

sqlsql