The below example demonstrates filtering with custom datetime format M dd, yy hh:mm:ss (AM/PM) for Order Date and DD dd MM yy for Shipped Date column.
For Shipped Date ( with date format ), we just have to define
column.format, grid takes care of the rest.
For Order Date ( with datetime format ), we have to do some work to make up for lack of support of time formatting in jQueryUI:
yy-mm-ddThh:mm:ssare required in raw json data. We convert the dates to this format in
dataModel.getDatacallback for this demo although remote script is the ideal place to supply this formatting in first place.
column.formatfunction to supplement jQueryUI date formatting with time formatting. A third party library with time formatting support may also be used.
column.deFormatas counterpart to column format function.
filter.format = 'M dd, yy'i.e., date part only for jQueryUI datepicker used in filtering.