RDLC show date in French on US report

rsaritzky

Hi all,

I have a US-based client that needs a couple of reports for one of their customers who are in France. I want to display dates on these 2 custom reports in the "long" French format. Instead of 04/20/2011, display 20 AVRIL, 2011.

I can do it the "hard way" by manually converting the month-number to a French string by storing the French month names in an array or long string, but I'd like to try to use localization techniques.

I've seen some examples using the CultureInfo object and the ToString method, but I haven't seen a code example that works in RDLC. It's just the syntax of inserting the code into an RDLC function so it can be used. Here's a VB example that I found

Dim theDate As Date = #12/25/2005#
Dim MyCulture As New System.Globalization.CultureInfo("fr-FR")
TextBox1.Text = theDate.ToString("MMMM d, yyyy", MyCulture)

But I don't know how to convert this syntax so I can create a function in the "Code" window in an RDLC report so I can pass a date to the function and have it return the French date.

Has anyone tried this technique before?

Thanks

ara3n

Try and change the report language to French. or French Canadian.

CurrReport.LANGUAGE :=