SOLVED

Pivot Tables - Changing Date format

%3CLINGO-SUB%20id%3D%22lingo-sub-1258934%22%20slang%3D%22en-US%22%3EPivot%20Tables%20-%20Changing%20Date%20format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1258934%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20using%20a%20pivot%20table%3B%20when%20I%20select%20the%20date%20field%2C%20it%20automatically%20add%20quarter%20and%20year%20which%20is%20fine.%20My%20issues%20is%20when%20I%20select%20my%20original%20invoice%20date%20it%20only%20shows%20the%20month%20and%20not%20the%20complete%20month%20and%20date.%20It%20doesn't%20allow%20me%20to%20get%20the%20information%20of%20qty%20per%20day%20only%20by%20month.%26nbsp%3B%20I%20selected%20field%20setting%20but%20it%20does%20not%20give%20me%20the%20option%20to%20change%20the%20format%20to%20include%20day.%20I%20tired%20altering%20year%20or%20quarter%20as%20it%20shows%20up%20there%2C%20but%20it%20doesn't%20change.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1258934%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1258974%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Tables%20-%20Changing%20Date%20format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1258974%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F597735%22%20target%3D%22_blank%22%3E%40DynaProAshley%3C%2FA%3E%26nbsp%3BTry%20right%20clicking%20one%20of%20the%20months%20in%20the%20Pivot%20and%20Ungroup.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1258996%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Tables%20-%20Changing%20Date%20format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1258996%22%20slang%3D%22en-US%22%3E%3CP%3EBrilliant!%20That%20solved%20my%20issues!%20Thank%20you%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F544433%22%20target%3D%22_blank%22%3E%40Savia%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I'm using a pivot table; when I select the date field, it automatically add quarter and year which is fine. My issues is when I select my original invoice date it only shows the month and not the complete month and date. It doesn't allow me to get the information of qty per day only by month.  I selected field setting but it does not give me the option to change the format to include day. I tired altering year or quarter as it shows up there, but it doesn't change.

2 Replies
Highlighted
Best Response confirmed by DynaProAshley (New Contributor)
Solution

@DynaProAshley Try right clicking one of the months in the Pivot and Ungroup.

Highlighted

Brilliant! That solved my issues! Thank you@Savia