Forum Discussion
Date values not recognized by pivot table
I have a table with a date column (Called "date"), that are clearly formatted as strings (left aligned). In a new column (Called "date1") I convert these values to real dates with @datevalue. Whe...
What happens if you attempt to group the dates in the pivot table via right-click a date | group ?
I found the solution! After I create the pivot, I first have to save my file. Then teh dates behave like expected.