Kendo grid date column not formatting

Question

I have a KendoGrid like below and when I run the application  I m not getting the expected format for date column       empGrid   kendoGrid       dataSource            data  empModel Value          pageSize  10             columns                          field   Name               width  90              title   Name                                    field   DOJ               width  90              title   DOJ               type   date               format   0 MM-dd-yyyy                          When I run this  I m getting  2013-07-02T00 00 00Z  in DOJ column  Why it is not formatting  Any idea

User · Answer

just need putting the datatype of the column in the datasource

dataSource: {
      data: empModel.Value,
      pageSize: 10,
      schema:  {
                model: {
                    fields: {
                        DOJ: { type: "date" }
                            }
                       }
               }  
           }

and then your statement column:

 columns: [
    {
        field: "Name",
        width: 90,
        title: "Name"
    },

    {
        field: "DOJ",
        width: 90,
        title: "DOJ",
        type: "date",
        format:"{0:MM-dd-yyyy}" 
    }
]

User · Answer

I found this piece of information and got it to work correctly  The data given to me was in string format so I needed to parse the string using kendo parseDate before formatting it with kendo toString   columns                  field   FirstName           title   FIRST NAME                       field   LastName           title   LAST NAME                       field   DateOfBirth           title   DATE OF BIRTH           template      kendo toString kendo parseDate DateOfBirth   yyyy-MM-dd     MM dd yyyy                    References    format-date-in-grid jsfiddle kendo ui date formatting

User · Answer

As far as I m aware in order to format a date value you have to handle it in parameterMap       listDiv   kendoGrid               dataSource                    type   json                   serverPaging  true                  pageSize  10                  transport                        read                            url    Url Action   ListMy    Placement                             data  refreshGridParams                          type   POST                                             parameterMap  function  options  operation                            if  operation     read                                 var d   new Date options StartDate                               options StartDate   kendo toString new Date d    dd MM yyyy                                return options                                                    else   return options                                                              schema                        model                            id   Id                           fields                                Id    type   number                                 StartDate    type   date   format   dd MM yyyy                                 Area    type   string                                 Length    type   string                                 Display    type   string                                 Status    type   string                                 Edit    type   string                                                                         data   Data                       total   Count                                               scrollable  false              columns                                                                  field   StartDate                           title   Start Date                           format    0 dd MM yyyy                            width  100                          If you follow the above example and just renames objects like  StartDate  then it should work  ignore  data  refreshGridParams     For further details check out below link or just search for kendo grid parameterMap ans see what others have done   http   docs kendoui com api framework datasource configuration-transport parameterMap

User · Answer

Try formatting the date in the kendo grid as   columns Bound x   gt  x LastUpdateDate  ClientTemplate     kendo toString LastUpdateDate    MM dd yyyy hh mm tt

User · Answer

The option I use is as follows   columns Bound p   gt  p OrderDate  Format   0 d    ClientTemplate    formatDate OrderDate       function formatDate OrderDate        var formatedOrderDate   kendo format   0 d    OrderDate        return formatedOrderDate

User · Answer

This might be helpful   columns Bound date  gt  date START DATE  Title  Start Date   Format   0 MM dd  yyyy

User · Answer

This is how you do it using ASP NET    add  Format   0 dd MM yyyy HH mm ss             Html Kendo   Grid lt AlphaStatic Domain ViewModels AttributeHistoryViewModel gt                 Name  grid                Columns columns   gt                                 columns Bound c   gt  c AttributeName                   columns Bound c   gt  c UpdatedDate  Format   0 dd MM yyyy HH mm ss                                    HtmlAttributes new    class     big-grid                  Resizable x   gt  x Columns true                Sortable                Filterable                    DataSource dataSource   gt  dataSource                  Ajax                    Batch true                   ServerOperation false                           Model model   gt                                                        model Id c   gt  c Id                                                     Read read   gt  read Action  Read AttributeHistory    Attribute    new   attributeId   attributeId

[date] Kendo grid date column not formatting

Examples related to date

Examples related to kendo-ui

Examples related to kendo-grid