title: Unable to sort pivot table by date
body: <p>I have a pivot table with 2 columns spanning dates (<code>Create Date</code> &amp; <code>Target Date</code>). I am unable to sort any field within my pivot table, but <strong>I need to be able to sort the date fields</strong>. I have double checked that the format is date (when changed to number format, the date serial is shown and <code>ISTEXT</code> shows <code>FALSE</code>)</p>
  <p>Photos of field list and relevant columns below. The bottom photo is just to drive home the point that the format is indeed date.<br />
  <a href="https://i.stack.imgur.com/w02bz.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/w02bz.png" alt="enter image description here" /></a>
  <a href="https://i.stack.imgur.com/bRPjd.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/bRPjd.png" alt="enter image description here" /></a>
  <a href="https://i.stack.imgur.com/fWS2H.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/fWS2H.png" alt="enter image description here" /></a>
  <a href="https://i.stack.imgur.com/6QVFl.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/6QVFl.png" alt="enter image description here" /></a></p>
  <p><strong>Will this not sort due to all fields being displayed under rows? Is there another way to sort this with the current set up?</strong></p>
  <p>I am open to VBA solution as I already have a macro that loops through each pivot for other reasons.</p>