Cannot group by Date in Pivot Table
That did not appear to resolve the issue. I even created a new Excel Report and I am not still not able to group on a date. The table is the CM Transaction and the Field is TRX Date.
I should have mentioned in my previous post that this dex.ini line will only work on Build 67 and 68. What build of SmartList Builder are you using? The only other option would be to convert the text date to a date within Excel.
We are on build 58.
If you would like to submit an answer or comment, please sign in to the eOne portal.