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

[MarlieHagen]

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.

[v-henryk-mstf]

Hi @MarlieHagen ,

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

 Best Regards,
Henry

[v-henryk-mstf]

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

[MarlieHagen]

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

[MarlieHagen]

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

[d_gosbell]

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. 

[d_gosbell]

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-usin... This definitely works for PBIX based reports so it may also work for RDL reports