Date given as string doesn't sort properly

[Madzie]

I am supplying a date in M/d/yyyy as string in a template for the column :
But when you sort the OrderDate column, it doen't seem to sort the dates properly - it puts the column values arbitrarly. Any clues why ??

model: {
                id: "MSOrderNumber",
                fields: {
                    OrderNumber: { type: 'string' },
                    OrderDate_String: { type: 'string' },

columns: [
            { field: "OrderNumber", title: "Order Number" },
            { field: "OrderDate_String", title: "Order Date", template: '#= kendo.toString(ConvertStringToKendoDate(OrderDate_String), "M/d/yyyy" ) #' },

Using this little function to get a formatted Date from string
function ConvertStringToKendoDate(value)
{
    var escapeRegExp = function (str) {
        return str.replace(/[\-\[\]\/\{\}\(\)\*\+\?\.\\\^\$\|]/g, "\\$&");
    }
    var replaceAll = function (find, replace, str) {
        return str.replace(new RegExp(escapeRegExp(find), 'g'), replace);
    }
    var find = '-';
    if (value != null && value != undefined && value != '') {
        value = replaceAll(find, '/', value)
        value = new Date(value);
    }
      return value;

}

[Atanas Korchev]

Hi Madhuri,

The data source will sort those fields as strings because you have configured it that way. To sort them properly you must set the type of the field to "date". Here is a live demo: http://jsbin.com/iHUJeXEq/1/edit


Regards,
Atanas Korchev
Telerik

[David]

Sorry for the thread resurrecting...

I'm not sure why I'm not able to sort my date. I looked over the example you posted. My data has dates that are formatted "M/d/yy"... but I can't for the life of me get Kendo to know that it's not a string.

$("#giving-history-grid").kendoGrid({
            dataSource: {
                sort: { field: "date", dir: "asc" },
                schema: {
                    model: {
                        fields:{
                            date: {type: "date"},
                            fund: {type: "string"},
                            desc: {type: "string"},
                            name: {type: "string"},
                            type: {type: "string"},
                            amt: {type: "number"}
                        }
                    }
                },
                aggregate:[
                    {field:"amt", aggregate:"sum"}
                ]
            },
            sortable: true,
            filterable: true,
            scrollable: false,
            mobile: true,
            columns: [{
                field: "date",
                title: giveModel.local.giving.date,
                format: "{0:M/d/yy}",
                width: 100
            }, {
                field: "fund",
                title: giveModel.local.giving.fund
            }, {
                field: "name",
                title: giveModel.local.giving.name
            }, {
                field: "type",
                title: giveModel.local.giving.type,
                filterable: false
            }, {
                field: "amt",
                title: giveModel.local.giving.amount,
                attributes:{
                        style:"text-align:right;"
                    },
                format: "{0:c}",
                footerTemplate: giveModel.local.giving.total+": #= kendo.toString(sum,'c') #"
            }]
        });

[David]

I just realized after tinkering more with that jsbin above that if you change the format to my format ("M/d/yy") then it breaks in the jsbin as well.

Is this a bug or is this format not supported?

[Kiril Nikolov]

Hello David,

Can you please open a separate support request, with some sample data from your service response, where we can see the format of the date returned to the Grid? A working example will also help.

Thanks for the cooperation.

Regards,
Kiril Nikolov
Telerik

 

 

[David]

Will do. Thanks.