I have this formula, it is working without the date range condition but will show only the heading label if the date condition is added.

=QUERY({ARRAYFORMULA(UPPER(‘Line Items (V3)’!$B$1:$B$17068)),
‘Line Items (V3)’!$E$1:$E$17068,
‘Line Items (V3)’!$P$1:$P$17068},
“SELECT Col1, SUM(Col3)
WHERE Col2 >= ” & DATE(YEAR(TODAY()) – 5, 1, 1) & ”
GROUP BY Col1
ORDER BY SUM(Col3) DESC
LIMIT ” & $B$3 & ”
LABEL Col1 ‘VENDOR NAME’, SUM(Col3) ‘TOTAL AMOUNT’
FORMAT SUM(Col3) ‘#,##0.00′”,
1)
Help please!

Tried revising the date condition with this but still same result:

DATE(” & YEAR(TODAY()) – 5 & “, 1, 1)