title: jqGrid 4.5.2 with bit data and null dates returned
body: <p>Using jQuery 1.9.1 &amp; jqGrid 4.5.2 to create a grid on a web page.</p>
  
  <p>The data that's being returned from a SQL query has 2 date fields in it, along with a field that is declared as a Bit in SQL.  When I run the stored procedure in Query Analyzer, I get a valid date in the first date field, it shows a 1 in the bit field, and <code>NULL</code> in the second date field on the row.</p>
  
  <p>In the <code>colModel</code> of jqGrid, I have the 2 fields set up as follows:</p>
  
  <pre><code>{name:"AckSwitch",
  index:"AckSwitch",
  width:200,
  align:"left",
  sorttype:"text",
  xmlmap:"Rowset&gt;Row&gt;AckSwitch"
  },
  {name:"AckTime",
  index:"AckTime",
  width:60,
  align:"center",
  sorttype:"date",
  formatter:"date",
  formatoptions: {"newformat":"m/d/Y H:i" },
  datefmt: "m/d/Y H:i",
  xmlmap:"Rowset&gt;Row&gt;AckTime"
  }
  </code></pre>
  
  <p>When the <code>NULL</code> time is returned, the column in the jqGrid displays like:</p>
  
  <pre><code>NaN/NaN/NaN
  NaN:NaN
  </code></pre>
  
  <p>I had found an example where a null date as passed in and the above formatter returned as a blank in it, but mine only returns the NaN above.</p>
  
  <p>How do you  need to set up a formatter to allow null values in a date field in jqGrid?  And secondly, on the Bit field, can you create a custom formatter to show True/False instead of 1 or NULL (which is what it would be if not set).  Both fields would need to be sortable.</p>
  
  <p>Would appreciate any suggestions or guidance.  </p>
  
  <p>Thanks!</p>