Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
I have tried using:
=QUERY('Noah''s Weight'!A:D, "select * where A > date ' " &text(TODAY()-15;"yyyy-MM-dd" ) &" ' ")
Row 1 is the headers, column A is the time stamp from the form, and column 2 has the accompanying values I'm looking for.
You can use =QUERY(A:B, "select * WHERE datediff(now(), todate(A)) <= 15")
=QUERY(A:B, "select * WHERE datediff(now(), todate(A)) <= 15")
Required, but never shown