Displaying blanks in a column of dates
Any suggestions about handling blank values in the JavaScript array in a column of dates?
The blank dates appear as "" in the array. I get a result of #ERR in the grid where the blanks would otherwise appear.
I'm using, amongst other lines, the following code:
var date = new Active.Formats.Date;
date.setTextFormat("dd mmm yyyy");
formats = [number, number, string, string, string, date, date, string];
obj.setDataText(function(i, j){return formats[j].dataToText(myData[i][j])});
obj.setDataValue(function(i, j){return formats[j].dataToValue(myData[i][j])});
Is the problem with the array, with the date formatting etc?
Thanks in advance. And thanks for the great widget.
The blank dates appear as "" in the array. I get a result of #ERR in the grid where the blanks would otherwise appear.
I'm using, amongst other lines, the following code:
var date = new Active.Formats.Date;
date.setTextFormat("dd mmm yyyy");
formats = [number, number, string, string, string, date, date, string];
obj.setDataText(function(i, j){return formats[j].dataToText(myData[i][j])});
obj.setDataValue(function(i, j){return formats[j].dataToValue(myData[i][j])});
Is the problem with the array, with the date formatting etc?
Thanks in advance. And thanks for the great widget.
Justin
June 20,