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
