c# - Set date to tbd if it is a specific date -
i tried looking around site see if question has been asked before, can't seem find it. using mvc , have controller page reads data sqlserver database display them in view contains jqgrid. my question how take specific datetime value, "1900-01-01 00:00:00.00" , have displayed tbd? this code 2 datetime columns: schedule.estimatedqastartdate = (!reader.isdbnull(4)) ? reader.getdatetime(4) : (datetime?)null; schedule.estimatedorprojectedreleasedate = (!reader.isdbnull(5)) ? reader.getdatetime(5) : (datetime?)null; the jqgrid solution have formatter date column follows here jsfiddle sample created you. function formatdate(cellvalue, options, rowobject) { if(cellvalue=="1900-01-01 00:00:00.00") return "tbd"; else return cellvalue; }; "use strict"; var mydata = [ {id:"1", docgroupname: "2", date: ...