My frontend is using slick grid in aspx page i have a date column , can i here check for nulls from the database results which is returning to the user..?
under if condition can i check if thedate is null assign default value as getdate otherwise it return what ever we have in database.
Rather tahn this we are not doing anything in code behind file.here how can i check for null value in database..
{name: 'PublishedDate', placeHolder: '', required: false, type: 'date', column:'PublishedDate', friendlyName:'Published Date', width:110, formatter:formatters.shortDate },
Here comes the formatter
var formatters =
{
shortDate: function(row, col, v, d) {
var theDate = parseSqlDate(v);
if (theDate != null && typeof theDate == 'object')
return locale.format(theDate, { selector: 'date', formatLength: 'short', fullYear: true });
else
return "";
}
};
function parseSqlDate( ...
Go to the complete details ...