Forums

DataTable assumes that the DataSource will provide all the data in suitable JavaScript native data types, and DataSource is equipped to do this. In the responseSchema.fields array you can either list the name of the field or provide an object with key and parser properties, like:
{key:'someFieldName':parser:'number'}

DataSource has a built-in 'date' parser, which uses JavaScript's Date.parse() static function. If your date or time data comes in formats that Date.parse() cannot handle, you have to do your own parser function. The parser property takes either a string with the name of the built-in parser or a function that receives the value to parse and returns it parsed. Once the data is parsed in DataSource, DataTable should have no problem sorting it.

Satyam , I am sorry for the confusion. Let me mention my problem statement again.

I have to display four columns in my DataTable. Out of these four columns three columns should be displayed in format "MM/DD/YYYY" and the fourth column should be displayed in "MM/DD/YYYY HH:MM:SS" format which is a timestamp.

My server is sending XML response to DataSource. The response contains values for these columns in their respective required formats like "MM/DD/YYYY" and "MM/DD/YYYY HH:MM:SS". I have applied date parser in my datasource for all four of these columns. I have also used formatter:YAHOO.widget.DataTable.formatDate for these columns in my DataTable. This way sort works perfectly but my timestamp column does not display time portion and just displays date in "MM/DD/YYYY" format. So to display the time portion also, I tried to create my formatter which reads values from Date object and sets el.innerHTML with string having format "MM/DD/YYYY HH:MM:SS". So now using this formatter for timestamp column fixes my display problem but breaks sorting.

So please suggest if I am doing anything wrong here or is there is a better way to achieve this. I read that YAHOO.widget.DataTable.formatDate also support customizing date format based on the Locale but I want to display date in multiple formats in different columns in same DataTable. So looks like this is also not the option for me.

Thanks.