Help with Power Pivot date format [2018-12-31TT00:00:00]

[c_omran]

Hello,
I am building a pivot table based on a query data, the format for my "Journal Entry Date" is set to be Date in the query, however, in the pivot table when I try to refer to it, it shows as something like [2018-12-31TT00:00:00]. is there a way to just keep the date and remove the rest?

Thanks

 

[sijpie]

Does one of these sites offer a solution?

Learn How to Deal with Dates in a Pivot Table | Excelchat

Click here to learn how to deal with pivot table date data in Excel.

www.got-it.ai

How to Change Date Formatting for Grouped Pivot Table Fields - Excel Campus

Learn how to change the date formatting for a grouped field in a pivot table.

www.excelcampus.com