jQWidgets Forums

jQuery UI Widgets Forums Grid Grid Date Sorting Problem

This topic contains 1 reply, has 1 voice, and was last updated by  Develop101 10 years, 10 months ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
  • Grid Date Sorting Problem #58613

    Develop101
    Participant

    Hi,
    I have a small issue when sorting dates in the grid.
    I am using JSON Data to populate the grid and the date column is set to type ‘date’.
    The column on the grid is also set to date example below.

    { datafield: 'HRDate', filtertype: 'date', cellsformat:'dd/MM/yyyy',editable: false, text: 'High Risk<br/>Date', width: 70, cellsrenderer: cellsrenderer2, cellsalign: 'center', renderer: colHeaderStyle },

    The is not a date in every row so when I sort this is happening.

    
    08/02/2010
    09/03/2010
    
    30/03/2010
    
    04/03/2010
    

    Has anyone got any ideas why?

    Cheers

    Grid Date Sorting Problem #58615

    Develop101
    Participant

    Hi,
    I have sorted this myself. The JSON file had a   in the null dates and it doesn’t like it.
    I have removed these and now all is working perfectly.

    Many thanks.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.