Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
Clear All
new posts

    Date sort order in ListGrid (european format)

    I have been trying to get the date sort order to work correctly when the date is in european format. However listgrid is always assuming american format.

    Is there a setting I need to use for listgrid to change this ?

    #2
    Format and sort are totally independant. You are probably delivering your dates as String values instead of true dates. Fix that and sort works.

    Comment


      #3
      Sample date processing

      Here is what I do, how should I deliver the date so that sort order works


      Datasource field definition

      {title:'Course start date'
      ,required:true,canEdit:true
      ,useTextField:true,redrawOnChange:false,inputFormat:'DMY',displayFormat:'toEuropeanShortDate',name:'STARTDATE'
      ,type:'date'}

      Operationbinding data returns as

      ,"STARTDATE":"18-07-2009",

      Comment


        #4
        See the docs - date fields expect XML Schema standard format.

        Comment


          #5
          XML Schema

          Does that mean I have to use XML to pass data rather than JSON?

          Comment

          Working...
          X