Forum Discussion
Date Filter on Pivot Table
Hi, I have 2 raw data and I want to use them as a pivot table and filter it using date. One table is successful (Controller). But the other data doesn't show filter using date.
There is indeed a difference in the date format of the raw data.
Here I attached the raw data and the exceL.
Thank you
Many of the cells in column H contain text values instead of dates. You can easily see this if you widen column H. The text values will be left-aligned, while the real dates will be right-aligned.
Because of this, Excel treats column H as text.
Moreover, the 'real' dates have their day and month switched.
In the attached version, I have corrected both issues using Data > Text to Columns (in two steps, one for the date values and another for the text values)
2 Replies
Many of the cells in column H contain text values instead of dates. You can easily see this if you widen column H. The text values will be left-aligned, while the real dates will be right-aligned.
Because of this, Excel treats column H as text.
Moreover, the 'real' dates have their day and month switched.
In the attached version, I have corrected both issues using Data > Text to Columns (in two steps, one for the date values and another for the text values)
- thanks for the answer, very helpful.
