Google-sheets – How to make a query with Google Spreadsheets that returns items from past 15 days

google sheetsgoogle-sheets-query

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.

Best Answer

You can use =QUERY(A:B, "select * WHERE datediff(now(), todate(A)) <= 15")

Related Solutions

Google Sheets – How to Make a Query That Checks for a Date

I couldn't find the trick for the real date cell to work yet, but you could have a work around if nothing else by adding the the single quote (') before the date in a format: YYYY-MM-DD in the Q4 cell.

That single quote means that the it will be parsed as string.

Google Sheets – How to Query Using Several Different Values

As query language documentation says,

You can join multiple conditions using the logical operators and, or, and not. Parentheses can be used to define explicit precedence.

Example:

select * where J = 'Guest Speaker' or J = 'Field Trip' or J = 'Anything'

Best Answer

Related Solutions

Google Sheets – How to Make a Query That Checks for a Date

Google Sheets – How to Query Using Several Different Values

Related Topic