Forums

Hello all,

I am using a custom formatter for displaying date . Both functions work fine in FF but not in IE 7/8 . Any help will be appreciated.

// Define a custom format function this is from YUI site as is
var myFormatDate = function (elCell, oRecord, oColumn, oData) {
var oDate = oData, sMonth;

switch(oDate.getMonth()) {
case 0:
sMonth = "Jan";
break;
case 1:
sMonth = "Feb";
break;
case 2:
sMonth = "Mar";
break;
case 3:
sMonth = "Apr";
break;
case 4:
sMonth = "May";
break;
case 5:
sMonth = "Jun";
break;
case 6:
sMonth = "Jul";
break;
case 7:
sMonth = "Aug";
break;
case 8:
sMonth = "Sep";
break;
case 9:
sMonth = "Oct";
break;
case 10:
sMonth = "Nov";
break;
case 11:
sMonth = "Dec";
break;
}
elCell.innerHTML = sMonth + " " + oDate.getDate() + ", " + oDate.getFullYear();
};

// This is using format under util.Date

var myFormatDate1 = function (elCell, oRecord, oColumn, oData) {
var oDate = new Date(oData);
elCell.innerHTML = YAHOO.util.Date.format(oDate, { format: "%b %d, %Y"}, 'en-US');;
};

// Column definitions
var myColumnDefs = [ // sortable:true enables sorting

{key:"Gender",label:"Gender"},
{key:"BirthDate",label:"DOB",formatter: myFormatDate1}

];


myDataSource.responseSchema = {
resultsList: "records",
fields: [

{key:"Gender"},
{key:"BirthDate",parser: 'date'}

]


" BirthDate" is of type date in MySql.
And setting parser to string displays date as in the db .


Thank you
Sucheta

Thanks Matt.

This is what I did.

My BirthDate column in db held value as date and as say 2010-06-02 .

I made the following changes in my code :

fields: [

{key:"Gender"},
{key:"BirthDate",parser: "string"}

],


And changed my second format function myformatDate1 function as

var myFormatDate1 = function (elCell, oRecord, oColumn, oData) {
var year=oData.substr(0,4);
var month=oData.substr(5,2);
var day=oData.substr(8,2);
var oDate = new Date(year,month,day);
elCell.innerHTML = YAHOO.util.Date.format(oDate, { format: "%b %d, %Y"}, 'en-US');;
};


and assigned it as

var myColumnDefs = [ // sortable:true enables sorting

{key:"Gender",label:"Gender"},
{key:"BirthDate",label:"DOB",formatter: myFormatDate1}

];

It works in both browsers now.

Thanks
Sucheta

Thanks Satyam and thanks Matt too.


Going by your suggestion Satyam this is what I have done now and it works in both browsers.

1. Defined a custom parser

var myDateParser = function (oData) {
var year=oData.substr(0,4);
var month=oData.substr(5,2);
var day=oData.substr(8,2);
var oDate = new Date(year,month,day);
return oDate;
};

2. applied to my field

{key:"BirthDate",parser: myDateParser},

3.set Date formatter in column

{key:"BirthDate",label:"DOB",formatter:YAHOO.widget.DataTable.formatDate},


4.and used dateOptions in config as below


dateOptions: {format:"%b %d, %Y"}


Hope I have got it right now
BTW I am just displaying some data , no editing.

Thanks
Sucheta

Thank You so much.

I have done as suggested by you .

Sucheta

So, it does in others? And even after doing it all still refuses to do it in IE?