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

Sorting on Date field according to MM/DD/YYYY

4 Answers 122 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Rahul Khinvasara
Top achievements
Rank 1
Rahul Khinvasara asked on 20 Oct 2008, 01:08 PM
Hi,
We are using Q1 2008 Rad controls in our application,We have a Rad grid,One of column of Rad grid is of DateTime Field,We want to perform Sorting in this Date time variable,But It is not sorting correctly..Previously You have suggested to use GridDateTimeColumn but  Still it is not sorting correctly,Actually our date format is mm/dd/yyyy So when we tried  GridDateTimeColumn then it is sorting according month then day but not according to year,but I want It 'll sort according to mm/dd/yyyy,Please suggest me how I'll handle this solutions.

Thanks

 

 

4 Answers, 1 is accepted

Sort by
0
Missing User
answered on 22 Oct 2008, 07:52 AM
Hello Rahul,


I tried to reproduce the described problem by preparing a test project, but unfortunately to no avail. Could you please modify the attached test project so the problem to appear and send us steps to reproduce the issue? Thanks for your cooperation.

Greetings,
Plamen
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.
0
Rahul Khinvasara
Top achievements
Rank 1
answered on 23 Oct 2008, 06:48 AM
Hi,
    Thanks for reply...We tried your given test application,but it works fine if our date is in year/month/day format,Because you application has hard-coded date in format of year/month/day.Actually in our application date is coming from data base and it is in format of  MM/DD/YYYY,So it's not sorted properly,When I returned date from database in Year/Month/Day format then It works fine but I want that It should sort when my date(Which is returned from database) is in MM/DD/YYYY format.
       As you have told to generate same problem in given test application,but unfortunately I can't attach that application because I m returning date from database.Please try to generate same problem in your local machine,For this take one table in database From where date will return in mm/dd/yyyy format ,then try to sort it.Then you'll understand what is the problem?

       Please reply as soon as possible...

Thanks
0
Missing User
answered on 23 Oct 2008, 08:00 AM
Hello Rahul,

I was not able to reproduce this issue. Can you please open a formal support ticket and attach a small runnable sample, in which we can observe the issue (it will be best if you modify my project)? This way we will be able to debug it locally and get back to you with our findings.

Best wishes,
Plamen
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.
0
Rahul Khinvasara
Top achievements
Rank 1
answered on 30 Oct 2008, 09:52 AM
Hi,
Thanks for reply..But we have solved date sorting issue.

Thanks
Tags
Grid
Asked by
Rahul Khinvasara
Top achievements
Rank 1
Answers by
Missing User
Rahul Khinvasara
Top achievements
Rank 1
Share this question
or