Page 1 of 1
Problem with date time variable
Posted: Mon Sep 16, 2024 8:51 am
by peter.sulo
Hello, I have found a problem when selecting date from date picker.
Version: 2024.3.5
OS: Windows
Web browser (Chrome, Edge, Firefox) language: Czech
I have attached simple demo.
On the first run of report, everything works fine, the date displayed is the same as in date picker.
- screenshot_ok.png (16.33 KiB) Viewed 3006 times
When the date or time in date picker is changed and the time is > 12:00, it is displayed incorrectly in the report. It shows 12 hours less.
- screenshot_error.png (16.36 KiB) Viewed 3006 times
It happens only if web browser's language is Czech. In other languages like English, Slovak it works OK.
Thank you for quick fix.
Re: Problem with date time variable
Posted: Mon Sep 16, 2024 2:26 pm
by Max Shamanov
Hello,
We require more time to investigate the issue thoroughly.
We will let you know when we get any result.
Thank you.
Re: Problem with date time variable
Posted: Tue Sep 17, 2024 7:21 am
by Max Shamanov
Hello,
The best solution to display the date in all browsers and with the same time is to specify the localisation of the report.
Specify the Culture-Czech property and the time will always be displayed the same way, regardless of browser settings.
Thank you.
Re: Problem with date time variable
Posted: Wed Sep 18, 2024 2:27 pm
by peter.sulo
Hello,
I tested the example you provided, but it behaves the same.
After initial load of the report, the date is displayed correctly.
- screen1.png (16.67 KiB) Viewed 2908 times
Then I changed time to 18:13:16 and the display is wrong.
- screen2.png (16.5 KiB) Viewed 2908 times
It is even more visible when culture of the report is set to English. The displayed value is 6:13:16 AM instead of PM.
- screen3.png (16.94 KiB) Viewed 2908 times
This happens only if those mentioned browsers are in Czech language regardless of report's culture.
It's not only matter of display.
I have also tried using the variable as a parameter in sql query and it behaves the same. Instead of PM I get AM value and result of query is wrong.
Re: Problem with date time variable
Posted: Wed Sep 18, 2024 4:38 pm
by Max Shamanov
Hello,
We require more time to investigate the issue thoroughly.
We will let you know when we get any result.
Thank you.
Re: Problem with date time variable
Posted: Wed Sep 25, 2024 9:25 am
by Max Shamanov
Hello.
We have reproduced the issue and need some time to make an improvement.
We will let you know when we get any results.
Thank you.
#15503
Re: Problem with date time variable
Posted: Tue Oct 15, 2024 4:13 pm
by Max Shamanov
Hello.
We have made an improvement.
Please, check our next build when it will be available.
Thank you.