Supply chain | Supply Chain Management, Commerce

Date format for SSRS report

(0) Share

Report

Posted on by Liene

How I can change D365FO date format for SSRS report for all languages?
We need to have dd.mm.yyyy, but all the time we get the reports with mm.dd.yyyy.

User options/Preferences/Date, time, and number format is changed to the local; Time zone is correct. In the system we have correct date format (Delivery date, Confirmed ship date etc),

but on SSRS reports date is incorrect.

Note: if we use local language for RFQ report, we get correct date format. For RFQ in other languages Date format is incorrect.

PO confirmation report - anyway (in all languages) is incorrect (mm.dd.yyyy)

I have the same question (0)

All responses (4)

Answers (0)

Blue Wang on at

Like (0)

Report

Hi Liene,

You can try to use expression for that.

Please check this:community.dynamics.com/.../format-date-using-ssrs-expression

Was this reply helpful? Yes No
Sergei Minozhenko 23,093 on at

Like (0)

Report

Hi Liene,

You can take a look at configurable business document printouts as well, instead of using SSRS. At least format change is implemented without development in excel template.

docs.microsoft.com/.../configurable-business-documents-reporting-word-excel

Was this reply helpful? Yes No
Suggested answer

Muthusamy 4 on at

Like (0)

Report

Hi,

Use the below expression for Date conversion in report design.

To Change the Date format

=iif(IsNothing(Fields!TableField.Value),"",CDATE(Fields!ExpirationDate.Value).ToString("dd/MM/yyyy"))

For e.g.

1. CDate(Fields!TableField.Value).ToString("dd-MMM-yyyy") and the output will be 27-Aug-2020

2. CDate(Fields!TableField.Value).ToString("dd-MM-yyyy") and the output will be 27-08-2020

Thanks,

Was this reply helpful? Yes No
Abdulaziz Albloshi 365 on at

Like (0)

Report

If you are customizing the report, You can write the required format in "format" property of the field on SSRS report designer.

Otherwise use configurable business document printouts, docs.microsoft.com/.../configurable-business-documents-reporting-word-excel

Was this reply helpful? Yes No