This is a migrated thread and some comments may be shown as answers.

Not Sort correctly for date/datetime column with different culture

3 Answers 147 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Robert
Top achievements
Rank 1
Robert asked on 02 May 2016, 09:09 PM

Hi,

We have different cultures setup based on the user login.

We found an issue with grid sort, it seems sorting correctly with US culture, but it fails with UK or custom cultures.

thanks!

 

 

3 Answers, 1 is accepted

Sort by
0
Robert
Top achievements
Rank 1
answered on 03 May 2016, 04:36 PM

FYI, I have added "[DataType(DataType.Date)]" in the property and in HTML, I waw ","EventDateTime":{"type":"date","defaultValue":null}"

However, it doesn't work.

0
Robert
Top achievements
Rank 1
answered on 03 May 2016, 06:54 PM
issue found and fixed. because we do timeoffset to get local time and it converts to string even the schema still saying date. I ended up making sure after timezone offzet converting and it stay as datetime.
0
Pavlina
Telerik team
answered on 04 May 2016, 09:14 AM
Hello,

I am glad to hear that you managed to fix the problem on your own. Do not hesitate to let us know in case you need additional assistance.

Regards,
Pavlina
Telerik
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Tags
Grid
Asked by
Robert
Top achievements
Rank 1
Answers by
Robert
Top achievements
Rank 1
Pavlina
Telerik team
Share this question
or