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

[Audiovisual_Ser]

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

[Lynn]

Hi

+Walton Atizado Check out slices.

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

a slice.

[Aleksi_Alkio]

Check this one… https://productforums.google.com/forum/#!topic/docs/_ZDIBt062As;context-place=topicsearchin/docs/que...

[pbalerio]

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