title: Tabulator Cell datetime object - Need to Format
body: <p>I am attempting to reformat a datetime value in a cell that contains TZ UTC data.  An example value is: 2019-12-09T14:50:47.000Z-0500</p>
  
  <p>I need it to display as:
  MM/DD/YYYY HH:mm:ssXM  - ex: 12/09/2019 02:50:47PM</p>
  
  <p>Local time, of course.</p>
  
  <p>I have tried reading the moment.js doc without success.  Here is a snippet I have attempted.  The table shows up with "blank rows."  If I remove the formatting, the data shows correctly but not with the date and time format I would like.</p>
  
  <pre><code>{title:"Last Submitted", field:"createdOn", sorter:"date", formatter:"datetime", formatterParams:{inputFormat:"YYYY-MM-DD hh:mm:ss", outputFormat:"MM/DD/YYYY", invalidPlaceholder:"(Invalid date)"}},
  </code></pre>
  
  <p>Any assistance would be greatly appreciated!</p>
  
  <p>Ben</p>
  
  <p><strong>UPDATE BASED ON ANSWER 12/26/2019</strong></p>
  
  <p>Thank you again for responding.  However, this is perhaps an issue for the author of Tabulator since I copied the inputFormat and outputFormat verbatim into the column definition of a Tabulator component and it displays blank rows.  If I remove the column cell formatter (which is a wrapper around moment.js code), the list displays with the full timestamp (including UTC / zulu time).</p>
  
  <p>ex: 
  <strong>2019-12-09T12:50:47.000Z-0500</strong></p>
  
  <p>Expected result (either 24h or 12h format doesn't matter at this point - and I did try to remove the "A" for the AM/PM indicator)</p>
  
  <p>Unfortunately, I cannot upload the code for this project since it makes internal WS calls for JSON results (which is another issue - Remote Pagination does not appear to be working.)</p>
  
  <p>Here is the source code for the column:</p>
  
  <pre><code>{title:"Last Submitted", field:"createdOn", sorter:"date", formatter:"datetime", formatterParams:{inputFormat:"YYYY-MM-DD[T]HH:mm:ss.SSS[Z]Z", outputFormat:"MM/DD/YYYY HH:mm:ssA",invalidPlaceholder:"(Invalid date)"}},
  </code></pre>
  
  <p>As stated above, if I add the formatter, blank <strong>table</strong> appear and nothing else. If I remove the formatter all data is displayed including the unformatted date (well it's formatted in a way in which I nor my users will want).</p>
  
  <p>Any ideas would be greatly appreciated!</p>
  
  <p><a href="https://i.stack.imgur.com/ogdMG.png" rel="nofollow noreferrer">Image of Result with datetime formatter</a></p>