How can I query only the last 7 days to be able to automate and present a weekly report?
Please help!.. I’m now using this query where Column B is the date
=QUERY(‘VEHICLE LOG SHEET’!B5:M, “select B, D, E, F, G, H, I, J, K, L, M where C = ‘T-191’”)
Hi
+Walton Atizado Check out slices.
I think you should be able to do all you want with
a slice.
Check this one… https://productforums.google.com/forum/#!topic/docs/_ZDIBt062As;context-place=topicsearchin/docs/query$20filtering$20dates
Hi +Walton Atizado. I am not an expert but I would try a slice with an expression like this one as
Row Filter Condition:
AND ( TODAY()<=[ColB_label] + 7 ; [ColC_label] = “T-191”)