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

Report
All responses (
Answers (