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

(2) Share

Report

Posted on by BADRI NARAYANAN G

211

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

I have the same question (0)

All responses (1)

Answers (0)

André Arnaud de Cal... 301,035 Super User 2025 Season 2 on at

Like (2)

Report

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.

Was this reply helpful? Yes No