UPDATE:
When I created the new Pivot Table and actually selected the Date as one of the rows, miraculously, the Date (Month) option was added to the Pivot Table Fields selection pane.

I am now able to Pivot the data for the new month just added.

I've been doing this for years and never had this issue before, so don't know what happened.

Thanks for the support Pecoflyer