topic Re: Report builder not accepting Date parameter as dd-mm-yyyy in Report Server

Report builder not accepting Date parameter as dd-mm-yyyy

MarlieHagen — Fri, 29 Jul 2022 10:37:39 GMT

Hi, hope someone can help me.

I create a blank report with one parameter. I mark the parameter as datetime so that i can get a calendar.

I have one field that references the parameter to see what it shows.

If i select a date that is less than 12 days, it swops the month and date. So I guess it wants US date (MM-dd-yyyy) and I want UK (dd-MM-yyyy)

My regional settings is (dd-MM-yyyy)

I tried Report Localization Language as User language as well as en-GB

I cant change anything on the Server

I get this message after selecting a date on the calendar

The value provided for the report parameter 'DateFrom' is not valid for its type. (rsReportParameterTypeMismatch)

Any help would be much appreciated.

PS I think it is a server setting, but I cant change anything there. Only way out for me would propably doing away with the calendar control and let people put in a text box what date they want.

Re: Report builder not accepting Date parameter as dd-mm-yyyy

d_gosbell — Fri, 29 Jul 2022 22:27:17 GMT

There is no server setting for the language. There is just the language setting in the report itself and I think the other important thing are the browser settings. see https://darren.gosbell.com/2021/03/fixing-incorrect-date-formats-in-power-bi-report-server-when-using-chrome-or-firefox This definitely works for PBIX based reports so it may also work for RDL reports

Re: Report builder not accepting Date parameter as dd-mm-yyyy

MarlieHagen — Mon, 01 Aug 2022 05:51:14 GMT

Hi, thank you for your reply. I checked the Edge settings, they are fine. Problem is I am still busy with the report in Report Builder which is connected to a report server. Report builder itself does not accept the date. I dont see anything in the options menu. My computer's regional settings is is dd-MM-yyyy. Report builder wants it MM-dd-yyyy

Re: Report builder not accepting Date parameter as dd-mm-yyyy

d_gosbell — Mon, 01 Aug 2022 08:27:20 GMT

I would deploy this to the server and test it there. Sometimes you find minor differences in the report builder preview pane compared to the actual server. If it's still a problem on the server then it's definitely worth raising a support ticket.

Re: Report builder not accepting Date parameter as dd-mm-yyyy

v-henryk-mstf — Wed, 03 Aug 2022 10:06:52 GMT

Hi MarlieHagen ,

Whether the advice given by d_gosbell has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.

Looking forward to your feedback.

Best Regards,
Henry

Re: Report builder not accepting Date parameter as dd-mm-yyyy

MarlieHagen — Wed, 03 Aug 2022 10:11:48 GMT

HI Henry, problem not solved. I am waiting to hear from the server administrators. Maybe they have an idea. I tried many settings everywhere and the date still swops around. I am feeling very limited with Report Builder. Sure the problem will persist in BI as well. If I find a solution, I will post it here.

Many thanks

Re: Report builder not accepting Date parameter as dd-mm-yyyy

v-henryk-mstf — Thu, 04 Aug 2022 01:21:38 GMT

Hi MarlieHagen ,

Thank you for your feedback and I look forward to your further updates in the forum.😊

Best Regards,
Henry