How to get rid of 0-Jan-00 dates in my Pivot table?

  • Right-click on the field in the Pivot table layout.
  • Select “Format cell”.
  • Select “Custom Format” on the right and enter ‘d-mmm-yy;;(Please note the double semi-colons are the key).
in informXL Analyzer