Stimulsoft Business Intelligence System | Forum

Hello

I have a problem with datepicker, I want to display data between 01/01/2018 and 09/07/2018 but it shows me data between 01/01/2018 and 07/09/2018. when I delved into the solution, I found that it reverses the days with the months, in dateValues, there is 7/9/2018.

THANKS

Hello,

Could you please clarify what version and product you are using?
Also please send us a samplre report with test data that reproduces the issue.

Thank you.

Hello
i use the version 2024.2.1 from 4 March 2024, ASP.NET
you can find the ressource file and the mrt file.

Hello,

Please note that the datetime format depends on the web server localization where the designer is hosted.

Thank you.

Hello , thank you ,
dateTime are UTC and i don't see how that affects the date format

Hello

I wand to demonstrate the probleme with this couple of screenshots.
I would like to display the dates of birth which are between January 1, 1981 and September 10, 1981, I have the correct results (first screenshot), when i change my datepicker to september 9, 1981, the result of the August month disappears (second screenshot)
Datas squared with with red in the first capture should be also present on the second one.
I ensured by my own that the datas are provided by the server.

Hello,

We need some time to investigate the issue.
We will let you know about the result.

Thank you.

Hello,

Please check the attached file with some modifications.
The CSV file does not contain a data type and the date column is a string.
To change the data type from string to date, you need to use DataTransfromation.

Thank you.