Hi @usernicky : this is ridiculous that Quickbooks does not have a solution for this issue or cares enough to fix it, but the only solution worked for me and i have to use it every time is the one by @Charlie_K
September 14, 2021 11:19 AM
I'm creating a new column next to date column in Excel. I use function =Datevalue and click the column where the dates are from the QBO export. This converts General/Text type into date format. At least this worked for me and I was able to group dates again in pivots etc..
