How can I query only the last 7 days to be ab...

(Audiovisual Services Headend) #1

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’”)

#2

Hi

+Walton Atizado Check out slices.

I think you should be able to do all you want with

a slice.

(Aleksi Alkio) #3

Check this one… https://productforums.google.com/forum/#!topic/docs/_ZDIBt062As;context-place=topicsearchin/docs/query$20filtering$20dates

(Pablo Balerio) #4

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”)