19 янв. 2021 г. · Based on the Query Language Documentation, when you include date keyword you need to use a date with yyyy-mm-dd format.

13 дек. 2021 г. · I have a dynamic range of points of data that I would like to add a date filter by a cell reference and seem to be getting a 'parse error'.

19 нояб. 2023 г. · I am having an issue regarding my Query function in Google Sheets where I will reference a cell with a date in order for me to filter the data from a specific ...

22 авг. 2024 г. · Google Sheets manages dates, time and duration as serialized numbers, then uses cell number formatting to format how they are displayed.

29 янв. 2021 г. · 1st param of query can be referenced only as non-arrayed range like: =QUERY(INDIRECT(A1)) ____ where A1 contains range A1:C arrayed ranges like these are not ...

7 июл. 2022 г. · In Google Sheets, I am trying to query data from my 'ALL DATA' sheet that is between two dates. The two dates are in B1 and B2 of my 'CALCS' sheet.

2 мая 2014 г. · I'm having trouble figuring out a fairly simple QUERY statement in Google Spreadsheets. I'm trying to use a cell reference instead of static values and I'm ...

3 февр. 2021 г. · Im trying to compare one date cell to a column of date cells. I am using the query function to list out all the matching rows.

27 мая 2022 г. · I'd like to substitute the "Fruits" text value with a reference to a specific cell, like A2. That way if I change the value in A2 from "Fruits" ...

11 сент. 2021 г. · I need to fetch last week results, and I was guessig that the query below could work: =QUERY(gDisplay!A2:I;"SELECT sum(F) WHERE A > date '"&TEXT(TODAY()-8,"yyyy