Home

Pivot Table changing date format

%3CLINGO-SUB%20id%3D%22lingo-sub-836729%22%20slang%3D%22en-US%22%3EPivot%20Table%20changing%20date%20format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-836729%22%20slang%3D%22en-US%22%3Emy%20detailed%20report%20shows%20date%20as%2001%2F08%2F19%20(its%20an%20appointment%20date%20field).%20When%20I%20create%20a%20pivot%20off%20the%20detailed%20report%20its%20adding%20%22month%2C%20date%2C%20year%22%20and%20changing%20the%20format%20for%20my%20appointment.%20How%20can%20I%20get%20my%20date%20field%20to%20be%20the%20exact%20format%20as%20my%20detail%20report.%20I%20need%20this%20to%20eventually%20build%20a%20lookup%20table%20Example%20%3A%2001%2F08%2F19%20on%20report%20Pivot%20Table%20%3A%2008-Jan%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-836729%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EPivot%20Table%20changing%20date%20format%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
mmathes
Occasional Visitor
my detailed report shows date as 01/08/19 (its an appointment date field). When I create a pivot off the detailed report its adding "month, date, year" and changing the format for my appointment. How can I get my date field to be the exact format as my detail report. I need this to eventually build a lookup table Example : 01/08/19 on report Pivot Table : 08-Jan
Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies