FILTER() Documentation Example

[Eric_Schwartz]

filter() documentation shows the example:
FILTER([DateStart_wDay], [End] = “07:15:33”)

Using this syntax generates the error:
Function ‘FILTER’ should have exactly two parameters, a table name and a filter condition

Replacing [ table ] with “table” works. Is there a case where [table] is appropriate?

[Aleksi]

Where do you see it like FILTER([DateStart_wDay]…)?

[Eric_Schwartz]

Hi Aleksi,
It appears in the code editor, LISTS functions page, as the example for FILTER().

[Aleksi]

okay, thanks.

[Steve]

Eric_Schwartz:

Is there a case where [table] is appropriate?

Nope. The first argument to FILTER() must be a quoted or unquoted literal table or slice name, and may not be an expression.

[Eric_Schwartz]

Thanks again Steve.
Tagged as Bug-issues-errors