Forum Discussion
Date formating in a pivot table
I am having a challenge changing the date format in pivot tables. All my table seem to default to year, quarter, month; in lieu of the actual date. While there are times the prior format is useful, n...
RDALE2435 You can create an additional column in dataset with formula =TEXT(DATE,"DD-MM-YYYY") and use this date format in your PT which will not create any additional dataset in your PT.
Hope this helps.
Thanks for this workaround.
But it is a bit funny way to work with formats in expensive product
But it is a bit funny way to work with formats in expensive product
