day/month reversal datepicker

Stimulsoft Reports.WEB discussion
Post Reply
souhir
Posts: 24
Joined: Wed Feb 07, 2024 9:08 am

day/month reversal datepicker

Post by souhir »

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
Max Shamanov
Posts: 792
Joined: Tue Sep 07, 2021 10:11 am

Re: day/month reversal datepicker

Post by Max Shamanov »

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.
souhir
Posts: 24
Joined: Wed Feb 07, 2024 9:08 am

Re: day/month reversal datepicker

Post by souhir »

Hello
i use the version 2024.2.1 from 4 March 2024, ASP.NET
you can find the ressource file and the mrt file.
Attachments
filtreInversé.mrt
(7.51 KiB) Downloaded 42 times
VisitCountKpi2.csv
(3.07 KiB) Downloaded 50 times
Lech Kulikowski
Posts: 6271
Joined: Tue Mar 20, 2018 5:34 am

Re: day/month reversal datepicker

Post by Lech Kulikowski »

Hello,

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

Thank you.
souhir
Posts: 24
Joined: Wed Feb 07, 2024 9:08 am

Re: day/month reversal datepicker

Post by souhir »

Hello , thank you ,
dateTime are UTC and i don't see how that affects the date format
souhir
Posts: 24
Joined: Wed Feb 07, 2024 9:08 am

Re: day/month reversal datepicker

Post by souhir »

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.
Attachments
Fisrt screenshot.png
Fisrt screenshot.png (25.43 KiB) Viewed 768 times
Second screenshot.png
Second screenshot.png (18.61 KiB) Viewed 768 times
Max Shamanov
Posts: 792
Joined: Tue Sep 07, 2021 10:11 am

Re: day/month reversal datepicker

Post by Max Shamanov »

Hello,

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

Thank you.
Max Shamanov
Posts: 792
Joined: Tue Sep 07, 2021 10:11 am

Re: day/month reversal datepicker

Post by Max Shamanov »

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.
Attachments
filtreInverséChanged.mrt
(11.39 KiB) Downloaded 39 times
Post Reply