Format date depend on customer language

(0) Share

Report

Posted on by Martina Bergamo

1,470

Hi to all!

I want to create a string including a date, during the printing of the invoice layout. (For example: "Invoice date: 01/01/2014")

The problem is that the date is formatted depend on system's setup. I need to format the date depend on the language of the customer.

Any ideas?

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Martina Bergamo 1,470 on at

Like (0)

Report

RE: Format date depend on customer language

This is exactly what I need!

Thank you Denis!!!

Was this reply helpful? Yes No
Verified answer

Denis Macchinetti 16,444 on at

Like (0)

Report

RE: Format date depend on customer language

Hi Martina

Take a look at sinedax.blogspot.it/.../retrieve-format-for-numeric-and-date.html

Practically, the RetailENInfo class use the System.Globalization.CultureInfo class.

Was this reply helpful? Yes No
Martina Bergamo 1,470 on at

Like (0)

Report

RE: Format date depend on customer language

I have already the language. This isn't the problem. I wanto to format the date from code. For example:

in the table is saved : 01/01/2014 but for a german customer I want to print: 01.01.2014.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Format date depend on customer language

You need create a expression to format the report based on user language

as per my understanding you need to modify the RDP class of the report so that tmp table returned as dataset of the report should have user language

which you can use for date formatting

Please verify and update us if this workaround helps you.

Was this reply helpful? Yes No
Martina Bergamo 1,470 on at

Like (0)

Report

RE: Format date depend on customer language

Hi Dan!
Thank you for your reply!
In Visual Studio I have no problem. There is a property for the date format.
The reason why I need to put the date in a string, is that this string is the line header of the CustInvoiceTrans!
And if I want to export the invoice with AIF I need the complete string (with the formatted date) in the field SalesInvoiceTmp.LineHeader.

Was this reply helpful? Yes No
Dan Emreus 1,162 on at

Like (0)

Report

RE: Format date depend on customer language

Hi Martina,

I guess that you can either create a new field to the table SalesInvoiceHeaderFooterTmp and set date format depending on language and than use that field in the ssrs-report.

Or you can use an expression in the ssrs-report directly that formats the date depending on language.

/Dan

Was this reply helpful? Yes No