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
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
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,228 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156