Changing date format based on the user settings in UserInfo Table.

(2) Share

Report

Posted on by BADRI NARAYANAN G

209

Hello Friends,

I have a ssrs report with a set of labels with a date format(US region as of now).There is requirement to change this format to say day/month/year if it is en-GB(UK region).
As shown in the screenshot based on the value selected in date,time format.

Below there is a screenshot of how the labels look as of now in ssrs report.It is shown in US format since it is a hardcoded value in ssrs report.This is the value given in the report design =Format(Fields!DayFrom.Value, "ddd") + " " + Format(Fields!DayFrom.Value, "MM/dd").

Is there a way to change this label date format based on the user selection in date time and number format present in user preferences.Please let me know your inputs.

Thanks
Badri

Categories:

Dynamics 365 Finance

Microsoft Dynamics AX

All responses (1)

Answers (0)

André Arnaud de Cal... 294,125 Super User 2025 Season 1 on at

Like (2)

Report

Changing date format based on the user settings in UserInfo Table.

Hi Badri,

In case these are hardcoded labels, it will not look at the user preferences in Dynamics 365. You will need a customization to achieve your requirement.