How to affect the SSRS datepicker format for the Seychelles Locale?

Question

I have an SSRS report that has a start and end date parameter (set to the date/time type) so that the user can choose the date range. The report sets the Localization Language value based on a parameter that is passed in at run time.

This works great for en-GB but we have a customer in the Seychelles and when the localization is set to en-SC, the date format of the 2 parameters defaults to mm-dd-yyyy, but this is incorrect as the date format should be dd-mm-yyyy. Because of this, the user is unable to set the dates correctly as choosing the 31st January for example gives a 'The value provided for the report parameter 'startdate' is not valid for its type' error.

When I drop down the date picker and pick 31st January, it fills the date in as 31/01/2023 but then displays the error. I have my Windows Region set to "Seychelles" and Regional Format to "English (Seychelles)".

This is using the Winforms Report Viewer Control.

Answer 1

Hi @Mark Jerrom

Do you mean you want to format the date parameter as "dd-mm-yyyy"? It doesn't seem very easy.

I did a simple test, whether it is modifying the language of the report or modifying the settings of the computer region, the date parameter always maintains the "mm-dd-yyyy" format. In the end, only one method worked, that is, the rendering format of the date parameter will only change after the browser language is modified.

Of course it's just a format change, I select the date in the calendar control and it still renders the data correctly, but if you manually enter an incorrect date format it will give you the same error.

For more details, you can refer to this link: https://stackoverflow.com/questions/29775170/i-want-datetime-parameter-in-ddmmyyyy-format-in-ssrs-report.

Best regards,

Aniya

Answer 2

Sorry, not supported (yet), see

Supported languages and countries/regions for Power BI

Same rules for SSRS.