Forum Discussion

slohombre's avatar
slohombre
Brass Contributor
Feb 04, 2021

Date Hierarchy Problem - Want actual date not Month

Hi, all. I am putting together a simple pivot table and I am getting the Month in my date columns instead of the actual date format of 5/1/2021.

 

How do I tell the pivot table to give me the date format of "5/1/2021" and not "May"?

 

Many thanks,

 

Paul

 

Resources