day/month reversal datepicker
day/month reversal datepicker
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
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
-
- Posts: 824
- Joined: Tue Sep 07, 2021 10:11 am
Re: day/month reversal datepicker
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.
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.
Re: day/month reversal datepicker
Hello
i use the version 2024.2.1 from 4 March 2024, ASP.NET
you can find the ressource file and the mrt file.
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 87 times
-
- VisitCountKpi2.csv
- (3.07 KiB) Downloaded 91 times
-
- Posts: 6417
- Joined: Tue Mar 20, 2018 5:34 am
Re: day/month reversal datepicker
Hello,
Please note that the datetime format depends on the web server localization where the designer is hosted.
Thank you.
Please note that the datetime format depends on the web server localization where the designer is hosted.
Thank you.
Re: day/month reversal datepicker
Hello , thank you ,
dateTime are UTC and i don't see how that affects the date format
dateTime are UTC and i don't see how that affects the date format
Re: day/month reversal datepicker
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.
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 (25.43 KiB) Viewed 1301 times
-
- Second screenshot.png (18.61 KiB) Viewed 1301 times
-
- Posts: 824
- Joined: Tue Sep 07, 2021 10:11 am
Re: day/month reversal datepicker
Hello,
We need some time to investigate the issue.
We will let you know about the result.
Thank you.
We need some time to investigate the issue.
We will let you know about the result.
Thank you.
-
- Posts: 824
- Joined: Tue Sep 07, 2021 10:11 am
Re: day/month reversal datepicker
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.
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 82 times