datefmt: 'd.m.Y'

... did the job. 🙂 Thanks so far.

thanks for your comment on that. I did like you told me but it doesn't work. These are the treegrid options I use:

({

   url: 'https://...',
   datatype: 'json',
   sortname: 'start_date',
   sortorder: 'asc',
   rowList: [50,100,250,500,750],
   rowNum:100,
   mtype: 'POST',
   viewrecords: true,
   imgpath: 'https://...',
   width: '...',
   height: '...',
   pager: jQuery("#pager"),
   forceFit: true,
   treeGrid: true,
   treeGridModel: 'adjacency',
   ExpandColumn: 'prm_states.name',
   colModel : [
      { label: '...',name: 'prm_states.name',width: '650',align: 'left',sortable: true,search: true},
      { label: '...',name: 'state_owner',width: '200',align: 'left',sortable: true,search: true},
      { label: '...',name: 'prm_states.start_date',width: '100',align: 'center',sortable: true,search: false,
         formatter: 'date',
         formatoptions: {srcformat: 'Y-m-d',newformat: 'd.m.Y'},
         sorttype: 'date',datefmt: 'Y-m-d'}
})

Maybe the datatype "json" is the problem?

Greetings

- Marcel Karras

It is not a bug. The problem is that in tree grid mode the sorting is at client side. For this purpose you should set sorttype option in colModel in order all to work. Ok. See docs.

Best Regrds

Tony

I've found a problem by sorting a treegrid column by date. I used the same column model as in non-tree grids (there everything works fine) but the attempt to sort the date column will sort the date letter by letter. It seems if the date formatter I use isn't recognized correctly. I use the formatter "date" and the options "srcformat: 'Y-m-d', newformat: 'd.m.Y' " to display a localized date string.

The treegrid examples on the jqgrid demo pages don't show a date formatted column, furthermore the "Debit" column in the examples won't get sorted correctly either.

Is this a bug or am I missing something?

Greetings

- Marcel Karras