How to fix date value translation in a report?

(0) Share

Report

Posted on by LLEV

I would like to have my due date value translated based on the current report language.

If I try to do: FormatDateTime(Fields!DueDate.Value, DateFormat.LongDate), the date will be in french format (my current environment language) but my report is in dutch.Is there a way to fix that?

Thanks in advance

All responses (2)

Answers (0)

Suggested answer

YUN ZHU 73,339 Super User 2024 Season 2 on at

Like (1)

Report

RE: How to fix date value translation in a report?

Hi, just to add some info.

In Business Central 2023 wave 1 (BC22), Microsoft released the following new features, you can try them out.

Define regional settings per report using a region property
https://yzhums.com/35838/

New Language Selection table (2000000050)
https://yzhums.com/36738/

Hope this helps as well.

THanks.

ZHU
Suggested answer

Inge M. Bruvik 32,748 Super User 2024 Season 1 on at

Like (1)

Report

RE: How to fix date value translation in a report?

There is a codeunit called "Type Helper" that codeunit has a function:

procedure FormatDate(DateToFormat: Date; LanguageId: Integer): Text

That will return a correcly formatted date accoudring to the language id you provide.