Tags report sort transaction date

Conversation Helpful Tips
,
1

Is there a way to make the transaction dates in the Tags Report display the newest ones on top? Currently it’s displaying old ones first.

2 
=IFERROR(IFNA(QUERY({INDIRECT(Q5),INDIRECT(Q6),INDIRECT(Q7),INDIRECT(Q8),ARRAYFORMULA(","& INDIRECT(Q9) &",")},"SELECT Col1,Col2,Col3,Col4 WHERE Col5 CONTAINS "","&F4&","" AND Col5 != ',,' AND Col1 >= date '"&TEXT(O18,"yyyy-mm-dd")&"' AND Col1 <= date '"&TEXT(O19,"yyyy-mm-dd")&"' ORDER BY Col1 desc",0),"No results"),IFERROR(1/0))

If you update E9 (the first date in the date column) to the above formula, where the change I made is order by col1 > original was ASC > updated to DESC, then the order should be newest to oldest.

edited to use preformatted text.

3

That worked perfectly. Thank you!