Date format not working

[dikan]

I have strange issue with dates. In designer , report preview look ok. But in Blazor server application sometimes date format is not working.

Example where it works:

https://prnt.sc/uRUOFImh-_o5

Example where it doesn't work regardless if i use {BRRDR.DATPOC.ToString("dd.MM.yyyy")} or {Format("{0:dd.MM.yyyy}", BRRDR.DATPOC)} :

https://prnt.sc/xpGDhhwJ7eyC

I hope you can help me.
Thank you.

[Lech Kulikowski]

Hello,

Please send us a sample report with test data that reproduces the issue for analysis.

Thank you.

[dikan]

Hello,
since it is complicated report with a lot of database tables and subreports, we will need some time to prepare test data and sample report.
Thank you,

[Lech Kulikowski]

Hello,

Ok. We will wait.

Thank you.

[dikan]

Hello,
why is this not working any more:

[Lech Kulikowski]

Hello,

The Format function is return a string, but your variable is datetime.

Thank you.

[dikan]

My problem is that when I run the report on the IIS server my Blazor Application shows the wrong date format. I need dd.MM.yyyy but in this particular case I have MM/dd/yyyy what is not acceptable for my clients.
How can I customize the format for date no matter how it is defined on the local operating system?

[Lech Kulikowski]

Hello,

You can set the necessary culture property of the report. Or you Text Format option to set the necessary DateTime format.

Thank you.