Not Sort correctly for date/datetime column with different culture

4 posts, 0 answers
  1. Robert
    Robert avatar
    37 posts
    Member since:
    Aug 2015

    Posted 02 May Link to this post

    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!

     

     

  2. Robert
    Robert avatar
    37 posts
    Member since:
    Aug 2015

    Posted 03 May Link to this post

    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.

  3. UI for ASP.NET MVC is VS 2017 Ready
  4. Robert
    Robert avatar
    37 posts
    Member since:
    Aug 2015

    Posted 03 May in reply to Robert Link to this post

    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.
  5. Pavlina
    Admin
    Pavlina avatar
    6084 posts

    Posted 04 May Link to this post

    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
Back to Top
UI for ASP.NET MVC is VS 2017 Ready