Grid Sorting Problem:- in the sorting date is only taking date and month part. It is not taking year part

3 posts, 0 answers
  1. Manish
    Manish avatar
    64 posts
    Member since:
    Jul 2011

    Posted 10 Jul 2012 Link to this post

    Hi,

    I have a grid and in that i have by default sorting by date desc and default group by by date and i is by default expended. The problem is that the sorting order is desc of date but the date is only taking the date and the month part in the not measuring by the sorting.
     
    Please see the attachment.

    I have used following code for sorting and grouping

     <SortExpressions >
                                <telerik:GridSortExpression FieldName="UpdatedDate" SortOrder="Descending"/>
                            </SortExpressions>
      <GroupByExpressions>
                                <telerik:GridGroupByExpression>
                                    <GroupByFields>
                                        <telerik:GridGroupByField FieldName="UpdatedDate" SortOrder="Descending"  FormatString="{0:yy/mm/dd}" />
                                    </GroupByFields>
                                    <SelectFields>
                                        <telerik:GridGroupByField FieldName="UpdatedDate" />
                                    </SelectFields>
                                </telerik:GridGroupByExpression>
                            </GroupByExpressions>
                            <GroupHeaderTemplate>
                                <asp:Label Text='<%#String.Format("{0:MM/dd/yy}", Eval("UpdatedDate"))%>' runat="server"
                                    ID="lblDate" Style="font-weight: bold; color: Black;"></asp:Label>
                            </GroupHeaderTemplate>
  2. Eyup
    Admin
    Eyup avatar
    3005 posts

    Posted 12 Jul 2012 Link to this post

    Hello Manish,

    I have created a sample RadGrid web site using the provided code sample. On my side the sorting works as expected and takes into account the year too. Could you please ensure that your DataField's type is System.DateTime and not System.String? Please check out the attached application and try to distinguish the crucial differences between our projects.

    Regards,
    Eyup
    the Telerik team
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. Manish
    Manish avatar
    64 posts
    Member since:
    Jul 2011

    Posted 14 Jul 2012 Link to this post

    Hi Eyup,

    Thanks for your answer but i got the problem and it was that i was convert the date in database like Convert(string(10),updateddate,101)
    so it was converting as string but i need to show it as i convert mm/dd/yyyy now i have made a solution i add another column and i make sorting with date and it was in date format  when i have to show the date in the groupby heading than shows converted date and in the shorting column i used the simple date column.


    Thanks for your reply.


    Thanks
    Manish
Back to Top